change background row color with change of date in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Urszula said:
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
Click to expand...

Assuming your dates are in column A and your first date is in cell A3,
use:

Format > Conditional Formatting > Condition 1 > Formula is

=MOD($A3,2)=0

Click Format > Patterns and choose the grey that you want.

Edit > Copy Cell A3 and Edit > Paste Special > Formats to all the cells
in your
range.
 
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 Format>Conditional 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
 
If you use Mod(day... you will get two adjacent same-coloured rows at
the end of a month with 31 days.
 
Oh, ok, I see what you mean:

1/31/2006
2/1/2006

Well, the posted example didn't "demonstrate" that that is how this is to be
used. <g>

Biff
 
Back
Top