Overwriting Conditional Formatting

[ce40424]

I applied a conditional formatting to some cells of an Ecel worksheet
(In fact, I color-banded the cells by using "=mod(row(),2)" formula).
Now there are 2 background colors: white (no color), and olive (rows
with conditional formatting applied).

The result is great, but I need to "overwirte" some cell formattings;
i.e. change some specific cell backgrounds. But it seems that
conditional formatting does not let me the change the cell backgrounds
from olive to any other color.

Is there a workaround?

 

[Ian]

The whole point of conditional formatting is that the formatting is applied
when specific conditions are met.

I see 3 possible options:

1. Is there some condition specific to the cells you need to reformat which
could be set as another condition? If so, please note that the first
condition to be met will be applied and any after that will be ignored.
2. Change the background colour in the current conditional formatting for
the cells you need to change (ie same condition is met, but the colour is
different.
3. Remove the conditional formatting on the cells, then change the
background colour.

 

[Bob Phillips]

CF will supercede any other formatting. You need to add an extra conditional
test, before the striping test, for this other condition.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)