[Solved] Applying conditional formatting independently to each other

maedosan Asks: Applying conditional formatting independently to each other

enter image description here
Here 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


Ten-tools.com may not be responsible for the answers or solutions given to any question asked by the users. All Answers or responses are user generated answers and we do not have proof of its validity or correctness. Please vote for the answer that helped you in order to help others find out which is the most helpful answer. Questions labeled as solved may be solved or may not be solved depending on the type of question and the date posted for some posts may be scheduled to be deleted periodically. Do not hesitate to share your response here to help other visitors like you. Thank you, ten-tools.



(adsbygoogle = window.adsbygoogle || []).push({});