conditional formatting refferencing another cell
Try the below formula in cell A1
=IF(B1<60,"Good",IF(B1<80,"OK",""))
If you want to return blank when B1 is blank try the below
=IF(B1="","",IF(B1<60,"Good",IF(B1<80,"OK","")))
If this post helps click Yes
---------------
Jacob Skaria
"Sudipto" wrote:
Hi,
I am working in exel 2007.
I want to put "good" in cell A1 if cell b1 is less than 60 and if greater
than 60 less than 80 i need to put "ok".
Please help
|