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.