May 25 2022 12:24 PM
I have been struggling to get Conditional Formatting to work using the following type of formula:
=AND($E2="Tech Spec: Svc: Evaluate",$F2>10,$F2<=20)
I would like to format the cell in column F a certain color when the cell in column E equals a specific string and the cell value in column F is between 2 values. I know the AND statement is working when I test it in a cell with a formula like
=IF(AND($E2="Tech Spec: Svc: Evaluate",$F2>10,$F2<=20),"Yes","No")
But when I try to use the AND formula in Conditional Formatting it doesn't work with 3 conditions.
I am trying to build a script that will create a spreadsheet and apply the Conditional Formatting with an AND statement with 3 conditions, but I can't seem to get it to work even in a plain old spreadsheet.
Any tips or suggestions would be appreciated.
May 25 2022 12:34 PM
SolutionYour rule for conditional formatting works perfectly in my sheet.
May 25 2022 12:38 PM
May 25 2022 12:39 PM
May 25 2022 12:50 PM
May 25 2022 01:24 PM
May 25 2022 12:34 PM
SolutionYour rule for conditional formatting works perfectly in my sheet.