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? Aug 19, 2020 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, 2020 at 15:39

1 Answer 1

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, 2020 at 12:08
  • A few days turned out to be a few months, but regardless, answer accepted!
    – JS Lavertu
    Jan 21, 2021 at 21:01

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

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