Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 86
Default How can I test for colour format in if statements?

I need to determine the colour of a cell and return the value if colour is
true. In other words, test the format of the cell.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default How can I test for colour format in if statements?

See:

http://www.cpearson.com/excel/colors.aspx
--
Gary''s Student - gsnu200843


"Colin" wrote:

I need to determine the colour of a cell and return the value if colour is
true. In other words, test the format of the cell.

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
Is there a logical test for a cell's format instead of contents Bruce Excel Worksheet Functions 3 November 17th 05 01:40 AM
Logical Test if statements with text--Excel 2002 Matt Excel Discussion (Misc queries) 2 November 2nd 05 11:32 PM
IF statements if the value is True it changes the cell colour? J. Kerr Excel Worksheet Functions 3 July 5th 05 05:14 PM
Can I fill colour in a excel cell from a return from an "IF" test. williamw Excel Worksheet Functions 1 March 24th 05 10:31 AM
If statements for time format Shesh Excel Worksheet Functions 1 February 11th 05 11:57 PM


All times are GMT +1. The time now is 05:09 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"