Urszula Wrote:
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

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.


--
CaptainQuattro
------------------------------------------------------------------------
CaptainQuattro's Profile: http://www.excelforum.com/member.php...o&userid=32763
View this thread: http://www.excelforum.com/showthread...hreadid=542781