Cell Formating

I would like to be able to format individual cells - what is the easiest way to do that?
For Example - I have months listed with the forecast for that month and I want the cell font to be red if the forecast goal was not met. However, further down the column - the forecast goal might be higher.
Comments
-
I would put the forecast in its own column before or after the Leads Referred and then do Conditional formatting to compare the two columns.
If Leads Referred is less than Forecast, then format the cell red.
-
To maintain the same layout, you could add a checkbox column (which can later be hidden) and use a formula similar to this...
=IF(AND(FIND("Forecast", [Time Period]@row) > 0, Leads3 > Leads4), 1)
This will look at the cell in the Time Period column and determine if the word "Forecast" is found. If it is found and the amount in the Leads column is greater than the amount below it, then it will check the box. You can then build conditional formatting to highlight rows based on that checkbox.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.2K Get Help
- 431 Global Discussions
- 152 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 74 Community Job Board
- 501 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 306 Events
- 36 Webinars
- 7.3K Forum Archives