AND doesn't work in Conditional Formatting/ Custom Formula

user_16168456 0
Viewed 39

I am working on a Custom Formula using Google Sheet's conditional formatting feature. When 2 things are TRUE, I want to change background and font color somehow.

I use the following statement to determine it =AND(F5:F10>30% ,$B$1 =True)

This works well and is tested independently, row by row.

Yet, when applied to the table only some columns are highlighted, not all

enter image description here

Below is a formula I am using enter image description here

google-sheets
1 Answers

try like this:

=($F5>30%)*($B$1=TRUE)
user_56326290
Related