Conditional Formatting query

TeeM

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?

Purnima Gore

Hi

You can't do a formula in the Conditional Formatting section but you can add an additional column with a formula as demonstrated below.

=IF(TotalYTD@row > BudgetYTD@row, "Yes", "No")

Then use conditional formatting

You can always hide the BudgetSum column as, the formula should copy through as you add additional items.

Hope that helps

ATB

Purnima

Purnima Gore

Hi

You can't do a formula in the Conditional Formatting section but you can add an additional column with a formula as demonstrated below.

=IF(TotalYTD@row > BudgetYTD@row, "Yes", "No")

Then use conditional formatting

You can always hide the BudgetSum column as, the formula should copy through as you add additional items.

Hope that helps

ATB

Purnima

TeeM

Excellent thanks Purnima👍️