when cell is lower then avarage how to turn them red
Hi i need a solution:
In my first row i have al the avarages from the rows next to it when the one of the cells next to avarage comes below the average i want them to turn red does anybody have a solution for that?
the yellow numbers are the avarage and the rows next to it are the statistics
thank you in advance!
Answers

Hi @roy9099,
You might consider using a helper column to accomplish this. Basically you'll use a formula in the helper column to apply a checked box to the column if it meets your criteria.
In your case, you would need 3 helper columns (checkbox type), the criteria would be if([Update Week 1]@row < Gemiddelde, 1, 0) which says if Update Week 1 column value for the current row is less than the Gemiddelde column value, then check the box.
Then your conditional formatting (you'll need 3 new rules, 1 for each column you're comparing to go along with each of the 3 helper columns) will state if the checkbox is checked, then highlight the column/cell red.
Here's another post explaining this in further detail: https://community.smartsheet.com/discussion/65831/conditionalformattingreferencingacell
Help Article Resources
Categories
Check out the Formula Handbook template!