Previous Topic Next Topic

ConditionalFormating: if cell a1 = 0% to 50%

Solved/Closed
Stormdronk - Aug 16, 2011 at 06:54 AM
 Stormdronk - Aug 18, 2011 at 07:34 AM
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 responses

Answer 1 / 4
sholly64 Posts 4 Registration date Tuesday August 16, 2011 Status Member Last seen August 16, 2011
Aug 16, 2011 at 08:46 AM
What version of Excel do you have?
Answer 2 / 4
Stormdronk
Aug 16, 2011 at 03:49 PM
Hi

2007

Thanks
Answer 3 / 4
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 120
Aug 18, 2011 at 05:26 AM
Use Conditional Formatting

then select

Format only cells that contains

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

Regards,
Rahul
Answer 4 / 4
Stormdronk
Aug 18, 2011 at 07:34 AM
Thanks Rahul

It worked fine!!!

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