Good Afternoon!
I am having trouble creating a conditional format that changes the cell colors based on a running total. Such that, when the total reaches 600 hours the format changes to another color. The problem is there will never be a time when the hours can be esxactly 600. How do I create a conditional format either in VBA or thru the "new rule" to format the hours from 1 to 600 with one type of formatting and then the hours between 601 to 1200 with another type of formatting? My cells are non-adjacent and thi is a calendar of sorts. please see pic for example. I want the cell that goes over 600 to have a gradient from the 1st format to move into the new format assocaite with hours between 601 and 1200.
I am having trouble creating a conditional format that changes the cell colors based on a running total. Such that, when the total reaches 600 hours the format changes to another color. The problem is there will never be a time when the hours can be esxactly 600. How do I create a conditional format either in VBA or thru the "new rule" to format the hours from 1 to 600 with one type of formatting and then the hours between 601 to 1200 with another type of formatting? My cells are non-adjacent and thi is a calendar of sorts. please see pic for example. I want the cell that goes over 600 to have a gradient from the 1st format to move into the new format assocaite with hours between 601 and 1200.