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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
Can I have a cell change to red/green if not equal to: 7
if true, if not nested if funcion 2
Nested Functions for Conditional Formatting Formula 3
Show in a Cell the Value for another Cell 2
Conditional Format 4
I'm an excel beginner please help 3
Need fucntion to reference cell on worksheet referenced by known n 3

Back
Top