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

[Hose]

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?

[ilanr01]

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