EXCEL: IF CELL B6 RED, HOW DO I GET A "W" (ie for win)to show up
 

Functions/Arguments Excel spread sheet. If cell B6 is colored red, how can
I get a "W" (ie=equal to "win") to show up in cell CG26?

Hose Wrote:
Functions/Arguments Excel spread sheet. If cell B6 is colored red,
how can
I get a "W" (ie=equal to "win") to show up in cell CG26?

If you dont want to use VBA, sorry I can't help you there, you can use
Conditional Format on B6, then use the same formula in CG26
Ilan


--
ilanr01
------------------------------------------------------------------------
ilanr01's Profile: http://www.excelforum.com/member.php...o&userid=26797
View this thread: http://www.excelforum.com/showthread...hreadid=466471