| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Checking a cell for a specific color in Excel VBA
I am trying to check a particular cell on a particular worksheet for
color to send a message. The cell I am testing contains a conditiona format that changes the cell's color in meeting the conditions. Onc the color changes, a message is sent. Anyone have any clues -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Checking a cell for a specific color in Excel VBA
With CF, you can't test the cell for a colour.
What you would need top do is to test whether the CF condition is being met. -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "ColdCore " wrote in message ... I am trying to check a particular cell on a particular worksheet for a color to send a message. The cell I am testing contains a conditional format that changes the cell's color in meeting the conditions. Once the color changes, a message is sent. Anyone have any clues? --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is there a way to color a cell if it meets specific condition | Excel Discussion (Misc queries) | |||
| Background color according to a specific cell value | Excel Discussion (Misc queries) | |||
| Are Error-Checking rules (in Excel Options) workbook-specific? | Excel Discussion (Misc queries) | |||
| Spell Checking with checking cell notes | Excel Discussion (Misc queries) | |||
| Can you assign specific color to cell using (if-then) functions Ex | Excel Worksheet Functions | |||
Hybrid Mode
