change background row color with change of date in a cell
Hi!
Do you want the entire row (column A to column IV) colored? Or, do you just
want a certain section of the row (A1:J1) colored? It's a waste of resouces
to color the entire row if you're not using the entire row.
Assume your dates are in the range A1:A3 and you want to color the range to
column J.
Select the range A1:J3
Goto FormatConditional Formatting
Formula Is: =MOD(DAY($A1),2)=1
Click the Format button
Select the Patterns tab
Click on the shade of gray you want
OK you way out
Biff
"Urszula" wrote in message
...
How do I change the background colour of the rows as the date in a cell
changes. So to get a 3D effect, eg:
29/5/06 = row grey
30/5/06 = row no colour
31/5/06 = row grey
Can this be done?
Urszula
|