IF formula when cell is $0.00

0

Hi - please help me with an IF statement, so I can highlight when a balance is zero dollars in one column... for example, the cell with the zero balance could turn the font red and bold, or highlight the cell in a color.

Answer
Discuss

Answers

1
Selected Answer

Hi Allison,

Select a range > Home tab > Conditional Formatting > Highlight Cell Rules > Equal to > Type $0.00 and make a choice of color. You may select other options like bold/ italic, etc. clicking on Custom Format.

Thank you!

Discuss

Discussion

Thank you, Chhabi.
Allison (rep: 6) Sep 11, '18 at 11:15 pm
You're welcome!
Chhabi Acharya (rep: 100) Sep 12, '18 at 4:04 am
Add to Discussion

Answer the Question

You must create an account to use the forum. Create an Account or Login