TransWikia.com

How do I conditional format a table in Google Sheets based on two other cell values?

Web Applications Asked by Rob Churan on November 3, 2021

In the scenario below, the table contains random integer values.
I want to use conditional formatting in order to highlight the values in the table between the specified min and max values.
While I could hard-code 2 and 15, those are subject to change, and I’m primarily looking for a way to adjust the format rules so that they are reading the values in A2 and B2, not 2 and 15.

Example sheet

One Answer

You can use the following formula under conditional formatting:

=AND(C5<$B$2,C5>$A$2)

enter image description here

(Adjust ranges to your needs)

Answered by marikamitsos on November 3, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP