2

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

Improve this question

1 Answer 1

Reset to default
2

try like this:

=($F5>30%)*($B$1=TRUE)
Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.