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