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.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
IF formula when cell is $0.00
0
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!
Discussion
Thank you, Chhabi.
Allison (rep: 6) Sep 11, '18 at 11:15 pm
You're welcome!
Chhabi Acharya (rep: 111) Sep 12, '18 at 4:04 am