Conditional formatting formulas

[Mike Harris]

Could someone help with formulas for conditional
formatting please. I am trying to do the following:

Red shading - cell value >+25 or <-25
Yellow shading - cell value between 10 and 25 or between -
10 and -25
Green shading for cell value between + 5 and -5

Thanks in advance.

 

[macropod]

Hi mike,

Say the cell you want to conditionally format is A1, format A1 with green
shading, then input two conditional formats as follows:

1. =abs(A1)>25, then select the red shading
2. = abs(A1)>10, then select the yellow shading

Cheers

 

[Bob Phillips]

Mike,

You can do it without formulae, CF allows a between option in its condition
, so use that.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)