A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Hi @Jo H
Thank you for posting your question in the Microsoft Q&A forum.
To achieve your formatting and logic goals in Excel, you’ll need to adjust both the formula and apply conditional formatting. Here's how to do both:
This version removes decimals and simplifies the logic:
=IF(Table13[@February]=0, IF(Table13[@March]=0, 0, 1), ROUND((Table13[@March]-Table13[@February])/Table13[@February], 0))
This will return:
-
0if both February and March are zero -
1if February is zero but March is not - Rounded percentage change (no decimals) otherwise
Besides that, Conditional Formatting Setup
- Select the column with the formula.
- Go to Home > Conditional Formatting > New Rule.
- Choose “Format only cells that contain”.
- Set up three rules:
Red for less than 0
- Rule: Cell Value < 0
- Format: Font color red
Green for more than 0
- Rule: Cell Value > 0
- Format: Font color green
Orange for equal to 0
- Rule: Cell Value = 0
- Format: Font color orange
I hope it helps, if you have any other questions, please feel free to reach out.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.