Conditional formatting using a formula

[ddub25]

I am not sure how to contruct this formula in conditional formatting. I know how to set the conditions, but just need help with the formula syntax.

IF AB14 = TODAY or any day in the past AND AC14 = "", then highlight W14 'RED', IF not, 'DO NOT HIGHLIGHT'

Any ideas. Thanks.

Dan

 

[barry houdini]

Try

=AND(AB14<=TODAY(),AC14="")

If AB14 might be blank you might want to introduce another check otherwise W14 will be formatted when the row is unpopulated, i.e.

=AND(AB14<=TODAY(),AC14="",AB14<>"")

 

[ddub25]

Thanks very much barry that does the job.

Dan