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

H

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?
 
I

ilanr01

Hose said:
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?
Click to expand...

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
 
Top