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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
check text color from conditional formatting w/out using VB
Answer this question and then use that answer as the logic of your formula:
Why are the cells red? Biff "slinger" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
check text color from conditional formatting w/out using VB
You need to replicate the conditional format criteria in a Cell or two...
There is no other way around it other than code. If you do want to investigate the code option here is a great resource... http://www.xldynamic.com/source/xld.CFConditions.html -- HTH... Jim Thomlinson "slinger" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
check text color from conditional formatting w/out using VB
I can do that, the problem I run into is then how to ignore the blank cells,
since there may only be three columns filled, or all 8, or any number in between. "Jim Thomlinson" wrote: You need to replicate the conditional format criteria in a Cell or two... There is no other way around it other than code. If you do want to investigate the code option here is a great resource... http://www.xldynamic.com/source/xld.CFConditions.html -- HTH... Jim Thomlinson "slinger" wrote: 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. |
Reply |
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 |