I'm having problems with conditional formatting!

**amoraali** · 05-31-2015, 03:26 PM

I have three conditional formating rules:
1. Expecting results of alternating row colours.

Please Login or Register  to view this content.

2. expecting cells containing "NTLF" to be white text on a red background.

Please Login or Register  to view this content.

3. expecting cells containing "!!!" to be black text on an orange background.

Please Login or Register  to view this content.

The first one works beautifully.

The second only works unexpectedly; The text colour changes on all cells containing "NTLF", but the background colour doesn't change on cells affected by the first rule. The cells in that column contain a selection box, which I think is where the trouble lies.

The third works fine on all rows, affected or not by the first rule.

My Question:
Why does the background colour of the second rule not change?

**etaf** · 05-31-2015, 04:05 PM

what order are the rules in?
and are you using stop if true ?

**amoraali** · 05-31-2015, 05:10 PM

Wayne,
Thanks. I put the first rule last and it works, with "stop if true" unchecked. I take the order is not one of appliction but priority?

Now, I have discovered that if I cut and paste a cell, the rule is not reapplied, meaning the background colour for the alternating rows is cut and pasted as well, even if I add new text to the cell. Not sure why that is. I've thought about using VBA to format the rows but am not sure if that would solve my problem.
Irvin.