0

enter image description hereHere is an example file for where I want to apply conditional formatting independently of each other

First I have highlighted all males in the spreadsheet

Then if they are a senior I want the text of the entire row to be bold but I can't seem to get it

The rows where the previous formatting has been applied do not have the second formatting applied

I can understand that if I make another rule where I check both conditions simultaneously I can get the desired result but I ultimately want to have several conditions so this method is not feasible

Any help with this would be appreciated

https://docs.google.com/spreadsheets/d/1cnpsPIZU5Vrz3ung0Dqmv67ECWk8ZaLF0bvtxN6FkGY/edit?usp=sharing

Improve this question
1

1 Answer 1

Reset to default
0

Conditional formatting rules are evaluated in the order they are shown in the list. The first rule that evaluates to a truthy value sets the format, and further rules are not evaluated after that.

This means that you need four custom formula rules:

=regexmatch($C2, "Senior") * ($B2="Female")

=regexmatch($C2, "Senior") * ($B2="Male")

=$B2 = "Female"

=$B2 = "Male"

See your sample spreadsheet.

Improve this answer
2
  • Thanks for the reply, I understand the solution but the number of rules I need to write double everytime I add a new condition so I was hoping to find a workaround
    – maedosan
    Jul 24, 2021 at 14:40
  • That is the way it goes if the criteria overlap — the number of rules grows quadratically. If the criteria do not overlap, the number of rules only grows linearly. One way to handle this with less rules is to format column by column, so that the "Senior" column is colored independently of the "Female/male" column.
    – doubleunary
    Jul 24, 2021 at 19:37

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.