Cell Formating

edited 12/09/19 in Smartsheet Basics

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
    Mike Wilday ✭✭✭✭✭✭
    edited 02/25/19

    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
    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.