| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
check text color from conditional formatting w/out using VB
I need a formula that checks the color of text in a cell that was applied
using conditional formatting. Unfortunately I cannot use any VB scripting since the security policy at my organization will not allow it. I don't even know if this can be done. If not I will be forced to have a miles long formula. If the text of the cells in any of 8 columns is red, then I need to copy information. The cell text can be either red, green, black, or the cell could be blank. I will need to ignore blank cells for this formula. I don't even know where to begin on this one. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to check for ANY text when conditional formatting? | Excel Discussion (Misc queries) | |||
| Conditional formatting of an entire row based on a cell text entry | Excel Discussion (Misc queries) | |||
| conditional formatting on specific text in cells | Excel Discussion (Misc queries) | |||
| Formulas dealing with text data | Excel Worksheet Functions | |||
| How do I apply conditional formatting to a text box | Excel Worksheet Functions | |||
Threaded Mode
