Easy Conditional formatting based on values of another column in Google Sheets

Before i’ve known the following tip, i used to format my cells in a google sheet based on the current day with indirection functions and such stuff. To check if the column A of the current row contains a date later than today, i used the following expression:

=INDEX(INDIRECT(ADDRESS(ROW();1;4,1)))>TODAY()

After a recent discussion with a colleague it could be made WAY easier. To conditionally format, e.g. the range of D6:N36 based on the date of the column A in the current row simply use instead:

=$A6 > TODAY()

and your’e done!

Sometimes life is way more simple than you think 🙂

Advertisements
This entry was posted in Uncategorized. Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

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