View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Petert[_2_] Petert[_2_] is offline
external usenet poster
 
Posts: 7
Default Conditional formating question

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)