ConditionalFormating: if cell a1 = 0% to 50%

Solved/Closed
Report
-
 Stormdronk -
Hello,

Hope someone can help?

I want to format a cell that changes % from a formula.

A1= 0-50% format B1 to green, and if A1= 50-100% format B1 to blue, and so on.......

This is probablu simple, but if I use the <> values the first formating overides the others,

For example =A1>0, will overide everything.

Hope this is clear, thanks for the help!!

4 replies

Posts
4
Registration date
Tuesday August 16, 2011
Status
Member
Last seen
August 16, 2011

What version of Excel do you have?
0
Hi

2007

Thanks
0
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Use Conditional Formatting

then select

Format only cells that contains

select "value" and "between" and put your values.

Regards,
Rahul
0
Thanks Rahul

It worked fine!!!

You can mark as solved thanks, dont know where to!
0