Conditional Formatting Dates

[ad192]

Hi,

I am trying to apply conditional formatting to cells with dates.


Excel conditional format.PNG

See attached image for reference please.

I want to say:

IF Cell A1 < Today AND Cell C1 = Open; Make Cell B1 a certain colour/format.

I want this to work on excel online as well however I dont think this is possible (I'm in Australia, date format might not allow conditional formatting - I have tried it already and the cells don't highlight). Can someone confirm please?

NOTE: Column C has data validation list for 'Open or Close'.

Cheers.

Regards,

Anthony

[etaf]

what have you used
perhaps load a sample here

select column B
then use a formula

IF Cell A1 < Today AND Cell C1 = Open; Make Cell B1 a certain colour/format.

=AND( $A1 < today() , $C1 = "OPEN")

will you have open in C without a date in A as shown
if so then that will also highlight as a blank cell will be less then today
to avoid those
=AND( $A1 < today() , $C1 = "OPEN", $A1 <> "")