Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Hose
 
Posts: n/a
Default 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?
  #2   Report Post  
ilanr01
 
Posts: n/a
Default


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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Possible Lookup Table Karen Excel Worksheet Functions 5 June 8th 05 09:43 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
How Can I make a cell flash in Excel monir Excel Discussion (Misc queries) 0 February 4th 05 03:41 AM
Excel: how to formulate conditional cell references centraloffice Excel Worksheet Functions 1 December 10th 04 08:57 PM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM


All times are GMT +1. The time now is 10:04 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"