Conditional formatting for Yearly Budget template

[stan]

I want to have over/under spending on the annual and monthly sections of the Yearly Budget template be different colors form the base colors. Does anyone have a formula for this? Thank you.

[Brad.warren]

Hi @stan:

Here is a great source for that:

Is there a way to make any positive number (income) green (or different color)?

Open your spreadsheet Select the range of cells that you want the formatting applied to (both negative & positive) Click Format in the main menu Click Conditional Formatting from the drop down menu Apply the desired rules in the right hand side block Google help article 78413: Use conditional formatting rules in Google Sheets G Suite Learning Centre: See data changes with conditional formatting