Help with function involving if then else?

[jbobzien]

Okay here's the problem. I want to take a percentage from two cells say
a1 divided by b1, and if that is 10% I want it a color say yellow, then
if it's 25% orange, and 50% or more red... now I can do any one of these
individually, but for some reason my brain can't lock around the concept
of doing three different ones depending on what I get? What am I missing
here, I cant' seem to put the formula together in my brain. Any help
would be appreciated....

--John

 

[Dav]

Look at formats _ conditional formating

If the percentage is in a cell

condition 1 cell value is greater than or equal to 0.5 format cell a
red

add

condition 2 cell value is greater than or equal to 0.25 format cell a
orange

add

condition 3 cell value is greater than or equal to 0.1 format cell a
yellow

Regards

Da

 

[jbobzien]

I forgot all about the conditional formatting option. I guess by no
figuring it out, it was my brain's way of saying there's an easier wa
of doing this!!!! haha
I appreciate it