I would like to request Experts help to convert the listed condition format formula into script/macro. The reason is the condition format has been deleted for some reason after a while and I need to manually recopy the whole formula back into the sheet. Hope by converting this formula into a script the current problem can be prevented. I attached the workbook as well for Experts perusal.
Red color condition: =AND($H7=TODAY(), $I7+TODAY()<=NOW()-TIME(0,
Green color condition: =AND(NOW()>=$H7+$I7,NOW()<
Yellow color condition: =AND($H7=TODAY(),$I7+TODAY