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
 All Categories
 14 Welcome to the Community
 Smartsheet Customer Resources
 62.8K Get Help
 376 Global Discussions
 207 Industry Talk
 440 Announcements
 4.5K Ideas & Feature Requests
 139 Brandfolder
 129 Just for fun
 130 Community Job Board
 449 Show & Tell
 30 Member Spotlight
 1 SmartStories
 284 Events
 33 Webinars
 7.3K Forum Archives
Check out the Formula Handbook template!