How do I override conditional format to modify color of 1 cell?

K

kevpandrews

I have used conditional formatting to stripe a large worksheet to make it
easier to read. I would like to color specific cells differently than the
striping. How can I override the conditional formatting to change the color
of individual cells?
 
S

Sean Timmons

Make the conditional formatting not include them?

Is there somethign about the cells that is the same or similar?
 
S

Sheeloo

I don't think you can overwrite conditional formatting...

Conditional formats have priority over formats that you apply directly to a
cell by using the Cells command (Format menu) or a Formatting toolbar button.

You may select the cells you want to format differently and remove
conditional formatting to them, if possible according to the logic you have
used...
 
S

Sean Timmons

Please note, conditional formatting looks at each case in order. So, if case
1 applies to all of your cells, it will never look at the 2nd case. Start
with the most restrictive case first.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top