Excel 2007 format a cell

  • Thread starter Thread starter Mike Johnson
  • Start date Start date
M

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
 
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.
 
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
 
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.
 
Back
Top