LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 38
Default Cell formatting and if statement

Is there a way to trigger an if statement based on the formatting of a
cell as opposed to the value in the cell?

I have a worksheet that displays channel frequencies in a grid
corresponding to various cities. All locations have each frequency,
but in some cities a given frequency can be in stereo or mono. In the
grid, a location with a frequency in stereo is denoted by a different
colour of text.

I would like to run an if statement from a macro that goes something
like:

if(textcolor(A1)=blue, true, false)

I assume that this isn't possible, but I am not confident enough to
give up on it.

Any help would be appreciated,
Thanks,
TK
 
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
Formatting Cells using an If Statement Seanb Excel Worksheet Functions 5 September 6th 07 05:10 PM
IF statement and color formatting for cell B1 for condition in A1 Rossta Excel Worksheet Functions 1 July 27th 06 12:37 AM
Can Excel cell formatting be included in an IF statement? neeses Excel Worksheet Functions 3 September 21st 05 07:42 PM
formatting a cell with a function (IF statement) Dreaming Excel Worksheet Functions 3 June 30th 05 02:26 AM
Formatting a cell with a function (IF statement) Dreaming Excel Worksheet Functions 2 June 30th 05 02:12 AM


All times are GMT +1. The time now is 09:53 PM.

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

About Us

"It's about Microsoft Excel"