Hi,
I have a Style called "Data" with background color white.
I create a conditional formatting rule and only set the ForeColor to red for example.
Now, I change the style "Data", the background color for example to Ivory.
Now, when the rule applies, I see the background color of white, that should be Ivory.
So, apparently the rule creates a copy of the style when creating the rule, and applies a background color that I do not think is part of the rule. I know other applications that do this differently.
I see two options I think are logical:
1) in the style rule, allow a base style to be inputed (data in my example)
2) When a rule applies, let me say what style to use. So, I have style "data", l create style "DataRule1" and say in my rule that when condition is met, style "DataRule1" must be applied.
Regards,
Erik
I have a Style called "Data" with background color white.
I create a conditional formatting rule and only set the ForeColor to red for example.
Now, I change the style "Data", the background color for example to Ivory.
Now, when the rule applies, I see the background color of white, that should be Ivory.
So, apparently the rule creates a copy of the style when creating the rule, and applies a background color that I do not think is part of the rule. I know other applications that do this differently.
I see two options I think are logical:
1) in the style rule, allow a base style to be inputed (data in my example)
2) When a rule applies, let me say what style to use. So, I have style "data", l create style "DataRule1" and say in my rule that when condition is met, style "DataRule1" must be applied.
Regards,
Erik