Excel 2007 format a cell

[Mike Johnson]

Hi,

Does anyone know how to format a cell automatically ?

I have a cell that changes fill color if its a weekday (eg. A1) but is there
a easy way to change A2 as well (thats the date - 1..31) ?

TIA

MJ

 

[Dave Peterson]

Use the same formula for the conditional formatting formula that you used for
the first cell.

Depending on what you're doing, just using the absolute address ($A$1 instead of
A1) may be enough.

 

[Mike Johnson]

OK thankz, I'll try to see if I can manage that.

But my first try didn't help. Maybe there is a trick

MJ

 

[Mike Johnson]

OK, I finally got the formatting to work. I just have to make 5 conditions
(10 in total). It's not nice but it works

Thankz again.