Conditional formatting with NOW() function

[richbriggs]

Hi Y'all,

I'm trying to make each row of cells highlight in red, if the current time is later than the time in a certain cell (Call+Slip), so Column C in the attached file.

I'm a complete newb to excel and this is probably fairly easy. Also, how, when you try 'Repeat Conditional Formatting', do you make it so each row corresponds to the Column C cell in that particular row? Is there a way of putting the formula in so instead of specifying the exact cell (e.g. $C$5), you can type something so it selects the cell in Column C in the row that is being formatted?

I'd really appreciate any help on this whatsoever as really need to get this done for work and feeling slightly out of my depth.

A massive THANK YOU in advance!!!

Rich

[Bob Phillips]

Select C5:C10

In CF, select New Rule>Use a formula, and add the formula =$C5>$L$1. Click Format and format to suit.

[richbriggs]

Thank you for your post Bob, although it doesn't seem to have worked for me...

Few problems, firstly, i want each row (A5-I5, A6-I6, etc.) to come red when the cell in Column C of that row is showing a time that has passed. I can select the row and conditionally format it all at once, so this isn't really a problem.

Howevever, your formula doesn't seem to work for me at all. It might be because I'm using an older version of Excel (and on a Mac) but I go to conditional formatting and add a condition, although I assume this is the same thing as adding a rule.

I then select 'Formula is' and input your formula, but it doesn't work. I can't really say much more being a newb.

***I also forgot to mention that it would be really helpful if I could get it to take the date in the beige bar into account, so that if the time has passed but it is a day later, it will not flash red.

[Bob Phillips]

It probably doesn't work because you have NOW() in the L1, which is date and time (I changed it to test to just time).

Try changing the formula to

=(TODAY()+$C5)>$L$1