when cell is lower then avarage how to turn them red

roy9099

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!

Ray Lindstrom

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/conditional-formatting-referencing-a-cell