Changing colour of cell on a certain date

[Guest]

hi guys

is it possible to change the colour a cell when the date in the box is
reached.

I have a spread sheet at work and have to do certain action on the 10th 14th
& 28th day i.e if the 10th day is 07/05/07 (today) can i get it to change
colour

thanks

 

[Guest]

Hi

Conditional Formatting will do it. Select the all cell(s) you want to
format. If the first cell in the range is B4 this is the cell we use.

Choose Format>Conditional Format. Set condition 1 to Cell Formula is and
type =DAY(B4)=10 in the input box. Choose the font color you want.

Click Add and for condition 2 type =DAY(B4)=14 in the input box. Do the same
for the third condition.

You can set up to three condition using Conditional Formatting. For any more
conditions you need VB

Regards
Peter