Conditional formatting for whole worksheet on excel 2007

[lp12345]

Hi there,

I'm trying to do conditioning formatting on excel 2007 involving dates. So for instance, I've got =today()-c2>0 for the cell c2. My question is how do I apply this to the whole worksheet?

Thanks

[Jonmo1]

Depends, do you want every cell to refer to C2 ?
Or do you then want C3 to refer to C3, C4 to refer to C4 ?

If you want the C4 to adjust according to which cell it's applied to, then you can just
Copy the cell that you already have working (C2)
Highlight all others
Right Click - Paste Special - Formats.


But if you want all cells to refer to C2, then change the formula to
=today()-$c$2>0
Then follow same steps as above.



Also, I would highly recommend designating a single cell to contain the =Today() function.
Say Z1 for example.
Then refer to that cell in all formulas.
=$Z$1-c2>0


This will greatly reduce calculation time.

[lp12345]

Depends, do you want every cell to refer to C2 ?
Or do you then want C3 to refer to C3, C4 to refer to C4 ?

If you want the C4 to adjust according to which cell it's applied to, then you can just
Copy the cell that you already have working (C2)
Highlight all others
Right Click - Paste Special - Formats.


But if you want all cells to refer to C2, then change the formula to
=today()-$c$2>0
Then follow same steps as above.



Also, I would highly recommend designating a single cell to contain the =Today() function.
Say Z1 for example.
Then refer to that cell in all formulas.
=$Z$1-c2>0


This will greatly reduce calculation time.

Thanks! Managed to work it out.

A follow up question, what if I want to set multiple conditional formatting on the same cell? E.g. If the value is great than 10, then it's white, if it's less than 10, it's yellow and if it's less than 0, then red. I tried to add another conditional formatting rule but I don't think the two are working together.

[Jonmo1]

It's all about the ORDER they appear in the Manage Rules window.
They are processed one at a time, from Top to Bottom
The first one to evaluate as TRUE is applied.

So I would say the order should be
1. Less than zero
2. Less than 10
3. Greater than 10