change color of a box with using if statements

[Mark M]

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

Thanks
Mark M

 

[Flick Olmsford]

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

 

[Mark M]

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

 

[Mark M]

I got it working thanks very much

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