when cell is lower then avarage how to turn them red

roy9099
roy9099
edited 01/25/23 in Formulas and Functions

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

  • Ray Lindstrom
    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!