If you use "Formula is", rather than "Cell value is", then you can use an
OR() condition.
--
David Biddulph

"sahafi" wrote in message
...
I need to have a conditianal formatting applied to my data as follow:
I would like to compare the condition to a value that changes, say every
month. On $A$1 I have my value 106.2%.

Condition1 when the value is between A1 and A1 + 0.05 = Yellow
Condition2 when the value is between A1 and A1 - 0.05 = Green
Condition3 when the value is = (A1 + 0.05) = Red
Condition4 when the value is between (A1 - 0.05) and 0.001 = Red
Otherwise no format (< 0.0001). Leave zero values without formatting.

I managed to get the first 3 conditions to work but not the last one as
Excel will allow only 3 condition plus the blank one. I have tried to add
additional two cells to hold the value of A1 plus 5% and A1 minus 5%, but
I
ended up with the same result. I have also tried the CFPlus Add in, but it
didn't work.
Any help is greatly appreciated.

Thanks.

--
when u change the way u look @ things, the things u look at change.