Conditonal Formatting if cell A is within a range of numbers to make cell B a different color

by Christopher Szarek   Last Updated July 11, 2019 01:03 AM

I am looking to create a conditional format that if a cell "A" is within a range of two numbers that cell "B" will then change color. Google Sheets. Please help.



Answers 1


  • for a number between 1.9 - 8.1

  • custom formula applied for cell B1 or range B1:B

    =($A1>=2)*($A1<=8)

    0

user0
user0
July 11, 2019 00:42 AM

Related Questions


Updated March 06, 2019 12:03 PM

Updated December 29, 2017 14:03 PM

Updated March 10, 2018 02:03 AM

Updated August 21, 2018 12:03 PM

Updated September 02, 2018 01:03 AM