Another If/Ten

  • Thread starter Thread starter Brian Bennett
  • Start date Start date
B

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.
 
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
 
Back
Top