Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Formatting Cells using an If Statement | Excel Worksheet Functions | |||
IF statement and color formatting for cell B1 for condition in A1 | Excel Worksheet Functions | |||
Can Excel cell formatting be included in an IF statement? | Excel Worksheet Functions | |||
formatting a cell with a function (IF statement) | Excel Worksheet Functions | |||
Formatting a cell with a function (IF statement) | Excel Worksheet Functions |