I amtrying to set up conditional formating, the plan is thus:

If I have numbers in cells M4 & O4 that total 3 or greater, the sum
will appear in P4, i.e. I have "1" in M4 and "4" in O4 the value of
P4 will be "5"

If the value in P4 is equal to or greater than "3" then I want the
text in M4 & O4 to be red.

Anyone any suggestions how I may achieve this?
--
Cheers

Peter

(Reply to address is a spam trap - pse reply to the group)

On Fri, 01 Oct 2010 23:40:07 +0100, Petert
<(E-Mail Removed)> wrote:

>I amtrying to set up conditional formating, the plan is thus:
>
>If I have numbers in cells M4 & O4 that total 3 or greater, the sum
>will appear in P4, i.e. I have "1" in M4 and "4" in O4 the value of
>P4 will be "5"
>
>If the value in P4 is equal to or greater than "3" then I want the
>text in M4 & O4 to be red.
>
>Anyone any suggestions how I may achieve this?


Sorry, should have mentioned I'm using Excel 2003
--
Cheers

Peter

(Reply to address is a spam trap - pse reply to the group)

Peter

Select M4 and O4.

Goto Format>Conditional formatting...

Select cell formula is, enter this formula and format as required

=$P4>3

If you need to apply this to more rows in columns M and O then select
the range(s) and repeat the above steps.

One thing you don't need to do is change the formula, Excel will
automatically adjust it.

eg in M5 & O5 it will be =$P5>3