Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
recognizing conditional formatting with VBA
Hello group.
Came across a situation today which I couldn't resolve to my satisfaction. Maybe someone here can help... A colleague needed me to code a spreadsheet with a fairly simple requirement. If a certain cell was green, the entire row would be colored green; if the cell was red, the entire row would be shaded red. The issue is the cell I'm basing everything off of is conditionally formatted. Trying to recognize the cell's color via cell.interior.colorindex does not work. I was unable to get any code to recognize the conditionally formatted cell. I finally resolved my problem by eliminating the conditional formatting and hardcoding the conditionally formatted formulas into the VBA module. So, does anyone know of a method to get VBA to recognize a conditionally formatted cell? Art |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
recognizing conditional formatting with VBA
You cannot "see" the formatting resulting being applied to a cell from
Conditional Formatting directly. The best you can do is have your code perform the same test that the Conditional Formatting is doing... if your test is True then so is the one the Conditional Formatting is evaluating, so then you know it is applying whatever formatting to the cell that was specified. Rick Rothstein (MVP - Excel) "c1802362" wrote in message ... Hello group. Came across a situation today which I couldn't resolve to my satisfaction. Maybe someone here can help... A colleague needed me to code a spreadsheet with a fairly simple requirement. If a certain cell was green, the entire row would be colored green; if the cell was red, the entire row would be shaded red. The issue is the cell I'm basing everything off of is conditionally formatted. Trying to recognize the cell's color via cell.interior.colorindex does not work. I was unable to get any code to recognize the conditionally formatted cell. I finally resolved my problem by eliminating the conditional formatting and hardcoding the conditionally formatted formulas into the VBA module. So, does anyone know of a method to get VBA to recognize a conditionally formatted cell? Art |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
recognizing conditional formatting with VBA
On Feb 10, 10:18*pm, "Rick Rothstein"
wrote: You cannot "see" the formatting resulting being applied to a cell from Conditional Formatting directly. The best you can do is have your code perform the same test that the Conditional Formatting is doing... if your test is True then so is the one the Conditional Formatting is evaluating, so then you know it is applying whatever formatting to the cell that was specified. Rick Rothstein (MVP - Excel) thanks - I had a suspicion the answer was going to be something along the lines of your response... Art |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
recognizing conditional formatting with VBA
See Chip's site.
http://www.cpearson.com/excel/CFColors.htm Gord Dibben MS Excel MVP On Thu, 10 Feb 2011 18:50:32 -0800 (PST), c1802362 wrote: Hello group. Came across a situation today which I couldn't resolve to my satisfaction. Maybe someone here can help... A colleague needed me to code a spreadsheet with a fairly simple requirement. If a certain cell was green, the entire row would be colored green; if the cell was red, the entire row would be shaded red. The issue is the cell I'm basing everything off of is conditionally formatted. Trying to recognize the cell's color via cell.interior.colorindex does not work. I was unable to get any code to recognize the conditionally formatted cell. I finally resolved my problem by eliminating the conditional formatting and hardcoding the conditionally formatted formulas into the VBA module. So, does anyone know of a method to get VBA to recognize a conditionally formatted cell? Art |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
Recognizing Cell Formatting To Use In A Formula Or Conditional For | Excel Worksheet Functions | |||
Conditional Formatting Recognizing Greatest Value | Excel Discussion (Misc queries) | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |