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!!

Insert the current date and time in cell a1
Disk boot failure insert system disk and press enter - Guide
Popcorn time - Download - Movies, series and TV
How to change time in whatsapp - Guide
We can’t review this decision because too much time has passed since your account was disabled. ✓ - Facebook Forum

4 replies

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!

Similar discussions

trying to have the current date go into one cell (A1)

If cell A1 has text then cell B2 has today's Date

lava hard reset & factory reset

How to specify macro for current active sheet

Enter current time in a cell by clicking it

Excel - IF function with multiple words

Similar discussions

Subscribe To Our Newsletter!