Change the colour of a row depending on the contents of a date cel

Change the colour of a row depending on the contents of a date cel

Post by R0I » Wed, 18 Jan 2006 21:31:02


Yes, you can use conditional formatting under the format option of the
toolbar. If you apply conditional formatting to say the first cell in the
column of choice, and assign your condition. Then you can copy that cell.
Highlight everything you want to apply that condition to in the column, and
paste special formatting. :) Task done.
 
 
 

Change the colour of a row depending on the contents of a date cel

Post by chris_cull » Wed, 18 Jan 2006 23:05:46

that almost does exactly what I want! work's brilliantly for the cell
with the date in it (when I conditionally format it to be less than a
cell with today() in it), but how would I get it to colour the whole
row in?

Cheers

Chris

 
 
 

Change the colour of a row depending on the contents of a date cel

Post by chris_cull » Wed, 18 Jan 2006 23:30:03

sorted - thanks for your help