[Solved] Set background color of row based on dropdown
Posted: Mon Feb 03, 2025 5:07 pm
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
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