0 Replies Latest reply on Jan 26, 2018 7:50 AM by John Powell

    Format where value is NULL for 2 consecutive months

    John Powell

      I've been trying to figure this out for a couple of days, hoping someone can help.

       

      I have this workbook, on the report for "Cons Months Billed" each month displays how many deals / sales they have done.  Currently it highlights each month cell green if the number is greater than 0 but red if it's less than 1.

       

      What I now need to do is highlight the consultant column where over the selected 12 month period they have a null value in any 2 consecutive months.