help with conditional formatting for one cell needed

[jam320]

I have a cell that calculated the ratio of two columns of data. So:

Cell C = (SUM(A:A))/(SUM(B:B))

I want the Cell C to change colors based on the quotient it returns:

<.50 = RED,
.50< & < .75 = ORANGE,
.75< & < .90 = YELLOW,
>.90 = GREEN

Is this possible? Thanks.

[etaf]

yes, you can setup 4 rules in conditional format

put them in order and stop if true

cell in c > 0.90 = GREEN
cell in c > 0.75 = YELLOW
cell in c >0.50 = ORANGE
cell in c <0.50 = RED
what do you want if equal to 0.5

can you post a sample spreadsheet

[jam320]

Sorry RED should be LESS THAN EQUAL TO .50

[etaf]

you said c - but your formula is in D1


have a look at the attached
= D1 > 0.90 = GREEN
= D1 > 0.75 = YELLOW
= D1 > 0.50 = ORANGE
= D1 <= 0.50 = RED

[jam320]

I was able to figure out what you meant by including the four conditions in the formatting rule section. I chose "format only cells that contain" for each condition which worked. Thanks for the information.

[etaf]

your welcome , thanks for the rep