Type "green" into B5 (without the quotes). Select C5. Click on Format -
Conditional Format. Select "Formula Is". In the formula block type
=B5="green" with the quotes. Select the Patterns tab and select the green
color you want. Click OK.
Done
HTH Otto
"exutable" wrote in
message ...

How would I make it so that if cell B5 says green then C5 is green?

I had something like this =IF(C5="green",,)


--
exutable
------------------------------------------------------------------------
exutable's Profile:
http://www.excelforum.com/member.php...o&userid=28665
View this thread: http://www.excelforum.com/showthread...hreadid=535363