I have Cells formatted like this:
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:
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.
baz
?