| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
If statement to test font color
I have seen this question in reverse on the forum. Usually the question is
to change the font color when criteria is met. I need to test the font color in order to determine value. I can do it in code with a for..next loop but I was wondering if it could be done in an if statement? Example: If(fontcolor (A2) = "Red", then "Next Day", "Standard") What would be the syntax? Thanks for the help. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I total only numbers with a specific font color? | Excel Discussion (Misc queries) | |||
| How do I change the font color based on results of an IF stateme | Excel Worksheet Functions | |||
| My fill color and font color do not work in Excel Std Edition 2003 | Excel Discussion (Misc queries) | |||
| calculate numbers based on font color? | Excel Worksheet Functions | |||
| can i chart my data in the font color? | Charts and Charting in Excel | |||
Threaded Mode
