Conditional format Column based on Week Date

P

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
 
A

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
 
C

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top