You have to do 2 things
1) use a formula with an if statement
=IF(A1=B1,"Y",IF(A1B1,"G",IF(A1<B1-1000,"R","Y")))
2) Format the cells
Format the cell colour as Yellow
Fomat_conditional formating
Cellvalue is equal to =”G” format green
Cellvalue is equal to =”R” format red
Celllvalue is equal to =”Y” format Yellow
But you are using yellow twice in your logic is this correct if so
=IF(A1B1,"G",IF(A1B1-1000,"Y","R"))
and use only the first 2 contional formating conditions
Regards
Dav
--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread:
http://www.excelforum.com/showthread...hreadid=541479