View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Make ZERO red and bold

No programming required. The topic you need to look up in Excel help is
"conditional formatting".
--
David Biddulph

"Marz" wrote in message
...
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