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

[Hugo Jorgensen]

Hi

There is an easy way.
First use the MAX function to determine what maximal value you have in the
set of data.
Then enter conditional formatting and as the criteria for egual to you can
use the cell reference where you have the MAX function.
As a general rule you should always use cell references in conditional
formatting and never enter values there.

Hugo Jorgensen

 

[Tree]

THANK YOU SO VERY MUCH T. VALKO!! This was EXACTLY what I was looking for in
my own situation... it is so wonderful that folks like you share your
knowledge to folks like me!! THANK YOU!

 

[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,