1

I am using conditional formatting to color lines based on a priority value in column A, this works fine.

I would like to add another rule that would italicize the lines that match a specific parameter, without changing the background color the previous rules have set. When I add this rule, the background color is overridden automatically. If I place the rule after the priority rules, I lose the italics.

Is there a way to change the italicization of a line only, with conditional formatting?

2
  • I think overlapping is not allowed. I could be wrong. How about using three conditions as a workaround? – Severus Snape Aug 19 '20 at 15:14
  • @SeverusSnape That would work, but it would double the number of rules I need... Not exactly a thrilling proposition. Oh well, if that's what's required, that's what it will be. – JS Lavertu Aug 19 '20 at 15:39
1

Example:

Rules:

Rules                            Format
------------------------------------------------    
Priority is 3; Alcohol           Red    
Priority is 3; Beer              Red and italics
Priority is not 3                None   

Sheet:

A         B
------------
Alcohol   3
Beer      4
Alcohol   5
Beer      3
Alcohol   4
Beer      5
Alcohol   3
Beer      4
Alcohol   5
Beer      3

Formula:

=AND(SEARCH("Alcohol",$A1),SEARCH("3",$B1))

=AND(SEARCH("Beer",$A1),SEARCH("3",$B1))

Sample screenshot:

Screenshot

2
  • 1
    I'll accept this as the answer in a few days, just want to keep it open in case someone else comes along. – JS Lavertu Aug 20 '20 at 12:08
  • A few days turned out to be a few months, but regardless, answer accepted! – JS Lavertu Jan 21 at 21:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.