Colors in cells depending on a value?
 

How to make Excel change the color in a cell if the cell's value is 1 ? Ex.
yellow
I do not want anything to happen if the cell's value is empty.

I use Office 2003.

RR

Colors in cells depending on a value?
 

Look up "Highlight cells that meet specific conditions" in help

"RR" wrote in message
...
How to make Excel change the color in a cell if the cell's value is 1 ?
Ex.
yellow
I do not want anything to happen if the cell's value is empty.

I use Office 2003.

RR

Colors in cells depending on a value?
 

In the Main Menu,
Format = Conditional Formatting

Cell value is equal to 1
set your color under the format button.

--
Regards,
Tom Ogilvy

"RR" wrote in message
...
How to make Excel change the color in a cell if the cell's value is 1 ?
Ex.
yellow
I do not want anything to happen if the cell's value is empty.

I use Office 2003.

RR

Colors in cells depending on a value?
 

Thanx a lot. :)

"RR" wrote:

How to make Excel change the color in a cell if the cell's value is 1 ? Ex.
yellow
I do not want anything to happen if the cell's value is empty.

I use Office 2003.

RR