Incorporating Cell color fill in an "if" logical function?

L

Luke

I am working in Microsoft 2007. I have a situation where I would like to use
the "red light, yellow light and green light" icons in the conditional
formating. However, I would like the icon to be placed into it's own cell.
My spreadsheet is generating a value and putting it into cell B1, lets say
the value is 1.4. In cell C1, I have manually put a value of 1.0. I would
like to use conditional formating so that one of the three icons shows up on
cell D1 based on the value of B1 in comparison to the value of C1.
Specifically if B1 is >= 1.0 then green, if B1 is between .99 and .90 then
yellow and below .9 then red.
Can you help? Thanks,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill tringle in a cell with color 1
Function for summing or counting cells based on a specified fill color 3
How do I convert shading to highlighting for specific colors 8
Conditional Formatting based on cell text 3
Word for Android background colors? (corrected) 0
how to format cells -fill color 2
If function using cell format as the condition 3
Cell Function/Font Color 2

Top