Hi Leona, I haven't looked at your posting in detail but I did something
similar for somebody else earlier in (in EXCEL 2007).

Check out:-

http://www.pierrefondes.com/

- item 50 towards the top of the page.

It may help.

Please hit Yes if my comments have helped.

Thanks.



"Leona" wrote:

I'm trying to get a cell color coded (B36) based on a formula result in
another cell (H3), based on several different parameters, i.e.:

If H360, I want cell B36 background to turn green
If H3 <=60 AND = 30, I want cell B36 background to turn yellow
If H3 <30, I want cell B36 background to turn red

I've tried multiple conditional formatting, IF functions, and simple
formulas and nothing seems to work -- I don't get any color formatting no
matter what formula variation I try.

Any suggestions?