Conditional format Column based on Week Date

[Pete]

Is it possible to automatically format a column based on a date in Row 1.

I have weekending dates across Row 1 and I would like to highlight the column that Today() would be in so that everytime I open the Sheet either the colour of that columns would be shaded or the borders of the cells would change to a Thicker format.

E.g

A1=01/01/13
B1=08/01/13
C1=15/01/13

If today() was 03/01/13 then Column A would be highlighted.

Thanks

Peter

 

[Ade Wherry]

Is it possible to automatically format a column based on a date in Row 1.



I have weekending dates across Row 1 and I would like to highlight the column that Today() would be in so that everytime I open the Sheet either the colour of that columns would be shaded or the borders of the cells would change to a Thicker format.



E.g



A1=01/01/13

B1=08/01/13

C1=15/01/13



If today() was 03/01/13 then Column A would be highlighted.



Thanks



Peter

Hi Peter,

Click on the cell A1 and then from the menu click Format -> Conditional Formatting

This will give you a dialog box where you can colour a cell based on set contions

e.g. Cell is Less than F1 (F1 being where the Today() formula is held).

Click on the format button to choose the format style

e.g.

Patterns - Colour Red

This will colour the cell red as the date is less than 03/01/13.

You could use Cell is greater than F1 to colour it green.

Hope this helps

AP

 

[Claus Busch]

Hi Pete,

Am Wed, 20 Mar 2013 13:17:39 -0700 (PDT) schrieb Pete:

A1=01/01/13
B1=08/01/13
C1=15/01/13

select your data => CF => Formula:
=AND(A$1<=TODAY(),B$1>TODAY())


Regards
Claus Busch