Conditional formatting and time

M

mndpy

I would like to change the color of a cell if there is a "Y" in one cell and
an "R" in another cell and if it is past 7:00pm. Any help on a formula would
be appreciated!
 
D

Darrilyn

You would have to do three separate conditional formats (format/conditional
formating) highlight the row(s) or column(s) that you want to change color
when the Y is present and say Cell Value is equal to in the drop down and
type in Y in the first box and then hit the format button and pick the color
or formatting you would like if the condition is met. Next click Add and
another box will appear and you will do the same thing with the "R" as you
did above with the Y and click add yet again and you will be able to do the
formatting for the past 7:00pm. Hope this helps.
 
Top