Conditional Formatting query

I have 3 columns - Monthly Budget, Budget YTD and Total Spent YTD.

I want any cells in the 'Total Spent YTD' column that are greater than the adjacent cells in the 'Budget YTD' column to highlight in a different colour. I don't seem to be able to do this with conditional formatting....or can I?

Best Answer


  • TeeM
    TeeM ✭✭✭

    Excellent thanks Purnima👍️