Format column depend on date cell

108 views Asked by At

How can I create a formula to color the font from the column if line 1 is today?

                   A            |       B         |       C
        1  |   21/11/2014       |   22/11/2014    |   23/11/2014
        2  |       xx           |      xxx        |       xx 
        3  |       xx           |      xxx        |       xx
        4  |       xx           |      xxx        |       xx

Can I create something automatic? Because I have many columns.

1

There are 1 answers

0
AdamL On

Format menu, Conditional formatting...

Select "Custom formula is", and enter:

=A$1=TODAY()

Check and select the desired text colour, and apply to all columns in your sheet (eg if your columns go to Z, then in Range type A:Z).