Another If/Ten

[Brian Bennett]

HI all.

Trying to use IF/THEN to look at Column A on one sheet, if any cell in that
column equals today() would like cells from that row to fill in another
sheet.

Is this possible? Any ideas on how to make that happen??

Thanks.

Flue.

 

[Dave Peterson]

Maybe you can use format|Conditional formatting.

Select the range to color (I used A2:X999).

With A2 the activecell, I did:
format|conditional formatting
formula is:
=($a2=today())
and give it a nice format