Look at Conditional Formatting (Excel 2003: Format -- Cells -- Conditional
Formatting).
You can select all of the cells with the formula in them and then set them
up so that when their value IS EQUAL to 0 (just type in the zero in the
appropriate area) to turn the font Red and make it Bold.
"Marz" wrote:
Hello
I am trying to set up a worksheet where totals produced by a formula
equaling zero will be red and bold.
I have looked at the number formatting, but that just does negative numbers
in red. I have also tried to read through the help files, but could not find
anything. Part of the reason for that is that I just don't know where to look
for an answer.
I am thinking that this might require programming, but I am not familiar
with those abilities in Excel. Is that what the Visual Basic button/window is
for? Would this require VB code? That is OK with me. I would like to learn
how to use that. I have programming experience. But, right now, I just don't
know how to proceed. What is my next step to get a formula quantity equal to
zero appear red and bold?
Marz