Prev: Limiting input by date
Next: Need help adding a formula to to cell with conditional formatting
From: "David Biddulph" groups [at] on 1 Feb 2010 10:32
No programming required. The topic you need to look up in Excel help is
"conditional formatting".
--
David Biddulph

"Marz" <Marz(a)discussions.microsoft.com> wrote in message
news:0FA37098-DF33-4E4E-85BB-34E92AF55024(a)microsoft.com...
> 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


From: Marz on 1 Feb 2010 14:50
To everyone who answered this: Thank you!

I should have added that I am using version 2007, but your answers led me to
the right menu. And, there is a great demo online for Conditional Formatting
in version 2007 here:

http://office.microsoft.com/en-us/help/HA101655491033.aspx

I didn't think that this was going to be so easy! There are a lot of options
available here.

"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
First  |  Prev  | 
Pages: 1 2
Prev: Limiting input by date
Next: Need help adding a formula to to cell with conditional formatting