๐Ÿ“‘ Conditional color formatting with custom formulas in Sheets

David Krevitt walks through creating a custom formula for conditional formatting. He is correct in saying that there are not many posts or reflections written about this. The formula that he uses (which can be found here) highlights a value found in a separate list in a separate tab:

=match($F12, indirect("'rangeTab'!$B$12:$B") ,0) 

I have used the following formula to highlight a whole row based on the contents of one cell:

=$O1="Yes"

Krevitt now has me wondering what else I could do.

One response on “๐Ÿ“‘ Conditional color formatting with custom formulas in Sheets”

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

To respond on your own website, enter the URL of your response which should contain a link to this post's permalink URL. Your response will then appear (possibly after moderation) on this page. Want to update or remove your response? Update or delete your post and re-enter your post's URL again. (Learn More)