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
Brian Bennett wrote:
>
> 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
|