VBA select date and the apply conditional format

[excel2learn]

Hi I am new here and am only a basic excel user. I was wondering if anyone could help me with the following:

I have a column of dates. I would like to have todays date back ground colour high lighted, and then tomorrows date back ground colour changed tomorrow.

if this makes sense:

If B3:B1000 = Now then change colour to green.

Thanks in advance

 

[villy]

Welcome aboard..
What you need to do is highlight the specified Range you want to apply Conditional Formatting then goto Format>Conditional Formatting>CellValueIs select equal to then in the inputbox type in =Today() or =Now() then click on Format button to choose color highlight from Pattern Pallete.

 

[excel2learn]

Thanks very much Villy-Voo, I did not realise it was that easy. I thought it would have to be VBA