Excel Help

pepp77 · 31 May 2011 at 14:53

Hoping someone can help me here.

I need to make a box turn red, yellow or green depending on the figure next to it and that figures relationship to 3 static numbers.

So in one box I have a figure of 20000, the 3 static rules are then:

turn red if under 15000, turn yellow if under 20000 and turn green if equal to or over 20000.

So in this instance the box would turn green.

Im guessing this is a conditional formatting using an IF function, but thats about all.

Any help appreciated.

Edit - forgot to say using Excel 2010.

AshenShugar1873 · 31 May 2011 at 15:30

Go into Format - Conditional Formatting.
Cell Value Is - Less than or equal to - 15000 or Cell Ref using pick box.
Click Format button and change colours as appropriate
Then click Add and get another row, same again but with 20000
Add again and make Greater than 20000

You can pick the Less Than/Greater Than/Equal to combinations as appropriate to your edge values. e.g. should 15000 be red or yellow.

pepp77 · 31 May 2011 at 15:35

AshenShugar1873 said:
Go into Format - Conditional Formatting.
Cell Value Is - Less than or equal to - 15000 or Cell Ref using pick box.
Click Format button and change colours as appropriate
Then click Add and get another row, same again but with 20000
Add again and make Greater than 20000

You can pick the Less Than/Greater Than/Equal to combinations as appropriate to your edge values. e.g. should 15000 be red or yellow.

Hi thanks for posting, was just about to post back to say I had managed to sort it out - using pretty much that exact method.

AshenShugar1873 · 31 May 2011 at 15:51

pepp77 said:
Hi thanks for posting, was just about to post back to say I had managed to sort it out - using pretty much that exact method.

Great minds and all that