change color of a box with using if statements

's Computer Specifications

Hey.
Can you change the color of a box with if statements? Examples (=if e7>0,
then change the box red)

Thanks
Mark M

's Computer Specifications

Why not use the Conditional Formatting Feature? Format menu | Conditional
Formatting.

"Mark M" wrote:

> Hey.
> Can you change the color of a box with if statements? Examples (=if e7>0,
> then change the box red)
>
> Thanks
> Mark M

's Computer Specifications

Thanks for a quick response Mr. Olmford
Can you give me an example on how to use a conditional format. I only can
use the basic comand in excel.

Thanks again and have a great day
Mark Melacon

"Flick Olmsford" wrote:

> Why not use the Conditional Formatting Feature? Format menu | Conditional
> Formatting.
>
>
>
> "Mark M" wrote:
>
> > Hey.
> > Can you change the color of a box with if statements? Examples (=if e7>0,
> > then change the box red)
> >
> > Thanks
> > Mark M

's Computer Specifications

I got it working thanks very much

"Mark M" wrote:

> Thanks for a quick response Mr. Olmford
> Can you give me an example on how to use a conditional format. I only can
> use the basic comand in excel.
>
> Thanks again and have a great day
> Mark Melacon
>
> "Flick Olmsford" wrote:
>
> > Why not use the Conditional Formatting Feature? Format menu | Conditional
> > Formatting.
> >
> >
> >
> > "Mark M" wrote:
> >
> > > Hey.
> > > Can you change the color of a box with if statements? Examples (=if e7>0,
> > > then change the box red)
> > >
> > > Thanks
> > > Mark M

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Useing IF statements to change a cell color	edward/	Microsoft Excel Misc	1	4th Dec 2009 04:08 PM
Change cell color for more than 3 conditional statements	=?Utf-8?B?S2F0aWU=?=	Microsoft Excel Worksheet Functions	1	5th Mar 2007 06:34 PM
can i setup if, then statements to change the color of a row	=?Utf-8?B?RWQ=?=	Microsoft Excel New Users	7	8th Aug 2006 11:59 PM
Bullet Font Color Changes When I Change Text Color--Can I Change it Back?	J. Danniel	Microsoft Powerpoint	2	17th Mar 2005 08:06 PM
Font Color and IF Statements	carlos	Microsoft Excel Worksheet Functions	4	28th Jan 2004 11:41 PM