Conditional Formatting Help

[InfoH]

Hi..

so in Row 2 I have a date
and in row 3-500 I have either blank cells or populated cells

I want to set conditional formatting to the blank cells only in the column where the date in row 2 matches todays date

I had tried this:

="AND(ISBLANK($F$3)=TRUE,$F$2=TODAY())"

didn't work though

any ideas?

 

[Zakkaroo]

this worked for me:

=AND(ISBLANK($F3),$F$2=TODAY())

part of your problem was that you put $F$3 - which means that the conditional formating will ONLY ever check if F3 is blank, it won't progress down to checking F4 etc.
I left the $ before F, but you could probably take that out too, it all depends whether it's just the F column you want to apply this too, or whether it's any additional columns

 

[InfoH]

perfect, thanks

I'm rubbish with conditional formatting! lol