Conditional format custom formula in google sheets

by user190579   Last Updated July 12, 2018 19:03 PM

Have a question on how to do a custom formula in conditional format for the following:

Column A1 = DCC220.....Column B1 = 7.50.....Column C1 = 7.00.....Column D1 = 7.60

I want to compare the result in B1 (7.50) to a range, C1 lower, D1 upper, but only if the value in A1 is DCC222. Color green if B1 is in the range of C1 and D1 and red if it is not.

Any help, thanks

Related Questions

Conditional If Formatting Based on Two Columns

Updated February 04, 2018 22:03 PM

How to use AND in Google Sheets w multiple criteria

Updated March 12, 2018 20:03 PM

Conditional Formating in Google Sheets

Updated April 07, 2018 20:03 PM