0

I have Cells formatted like this:

Twelve rows with Text in every fourth one

If the first cell of a triplet contains the word "baz" I want them formatted so there is a border around the triplet as well as some color adjustments.

However, in the way I did this ( =IF(A1="baz",TRUE,FALSE) as the condidion in each of the formatting rules, copying over the format resulted with the first cell of the formula as A1, A4, A7 and A10 respectively) the Borders only go around the individual cells. I understand why it does this, but i am looking for a better way.

Comparison:

Comparison

Is there a way to make a border around multiple cells using conditional formatting?

note: If this is a duplicate question then please link me to the solution and i will remove this one.

2
  • Are all the other colors/rows highlighted via conditional formatting? Or is that all manually done and you just need a condition for baz?
    – BruceWayne
    Sep 25, 2017 at 15:34
  • @BruceWayne The formatting is done manually Sep 26, 2017 at 5:59

1 Answer 1

0

You can use this conditional formatting formula:

="baz"=LOOKUP("zzz",$A$1:$A1)

applied to range:

$1:$12

enter image description here

2
  • Thanks for your answer! However, this is as far as i got myself with a less clean formula (ty), but my question was rather about having a border around the highlighted block, instead of removing all of the borders in the matching triplet Sep 26, 2017 at 6:05
  • @Laurenzebs ah didn't notice that. I'll take another look.
    – BruceWayne
    Sep 26, 2017 at 13:43

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .