Conditional format on columns with formulas and custom format
Posted by Kevin Mac on December 28, 2001 9:07 AM
I have 3 columns of time tracking data, each column contains formulas in each cell and each cell has a custom format as follows:
Formula = SUM(PENDING!$B3-PENDING!$A3)
Format = 28 Days & 11 hours & 01 Minutes & 39 Seconds
I am looking for a "conditional format" for each of the 3 columns to code the cells with a certain time range a different color dependant on the elapsed time.
I have tried and tried to conditionally format the columns but I get no result from the normal conditional format. Any suggestions are appreciated.