Cell Formating

@bethb

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.

Mike Wilday

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. 

Paul Newcome

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.