[Solved] Set background color of row based on dropdown

[SushiBear]

I am doing a basic inventory. So far I have it so I have a =SUM of the difference between actual physical stock and what the computer says we have to adjust properly, I have unit price and =SUM of unit • physical stock for total value.

I also have it set up to highlight the ROW red using conditional formatting with: $F4<$L4.

What I’m trying to do is set a second condition that if “Discontinued?” Is set to yes on the drop down, it puts the selected style I created for that even across the entire row (to the end not an entire row to #9999)

The conditionals I’ve tried are as follows;

=COUNTIF($N4=‘YES’) / ($N4=‘YES’)>0

=IF($N4=‘YES’) / (N4=‘YES’) /($N4=‘YES’)>0

$N4=‘YES’


I have been googling and searching responses on this forum board for a few days now. Nothing worked so far.

Any help?

Sorry for not having an ODS file, it’s on work PC and I can’t make an account on it here.

https://imgur.com/a/3RB9LAW

[Alex1]

Here's an example. Texts in expressions must be enclosed in double quotes, don't use curly quotes.