needhelp.xlsHi.
I am trying to use conditional formatting to color code a column of times.
The format is minutes:seconds
If the time is less than 3:30 it needs to be formatted with a green fill
If the time is 3:30-5:00 it needs to be formatted with a yellow fill
If the time is above 5:00 it needs to be formatted with a red fill
Basically the goal of the business is to have the time under 3:30 every day and my job is to rank and recap this performance.
So far I have tried going to formatting and choosing the mm:ss option
Then I highlight the entire column
I go to conditional formatting and create a new rule
Format only cells that contain cell value less than or equal to =time(3,30) and it says enter a valid formula
So I tried =time(3,30,0) and it let me do it
format fill green
Then when I run the rule nothing happens.
Please help!
Bookmarks