Conditional Formatting

[jo.stanley]

I am trying to change the colour of of a cell and need to use a formula to calculate the formatting

What I am trying to acheive is

A2 = 04/02/2011
A3 = 10/02/2011

If A3 is greater than today OR/AND A2 is greater than A3 it changes colour

Any ideas?
Thanks

 

[VoG]

Try the CF formula

=OR(A3>TODAY(),A2>A3)

 

[jo.stanley]

Thank s for your help.

Is there a way of doing this for an array

i.e row 2,3, 4 etc as the information I am formatting is different in each row.

 

[VoG]

Assuming that you are always doing a similar comparison, then if you select rows 2 down and apply that CF formula it should work.

 

[jo.stanley]

Sorry to appear completely useless - how do I do that

 

[VoG]

Select say A1:A10. Format > Conditional Formatting, select Formula Is and enter

=OR(A3>TODAY(),A2>A3)

then set your format and OK your way out.