Change cell color in Excel

Microsoft Book: ms office system plain s...
October 6, 2009 at 04:59:03
Specs: Windows XP

I want to change the colour of the cell when some value is entered in the cell and i want to configure this for the whole work sheet......

Can anyone help me on this, i know its a primitive question but i am fairly new to excel and can't find a way out of this

waiting for your response


See More: Change cell color in Excel

Report •

October 6, 2009 at 05:35:00

The simple answer is to use conditional formatting.

Conditional formatting allows the cell pattern colour, font and font colour, and borders to be changed based on what is in the cell.

Select the first cell, say A1, then from the toolbar Format-Conditional formatting ...

As a start, use Condition 1 and Cell Value Is
In the second drop-down select a condition, such as between.
Then in the next two cells enter values
select not equal to, which gives you one box to fill and enter =""
Select Format, and create the format you want when the cell meets your conditions.

The second option (not equal to / ="") will cause the cell to use the conditional format whenever there is an entry in the cell.

Now select the cell with the conditional formatting, and Copy it.
Select the cells you are going to use on your worksheet and PasteSpecial - Formats.

I suggest that you PasteSpecial only to the cells you are going to use, not to the full worksheet (remember there are over 65,000 rows on an Excel 2003 worksheet and 256 columns).

In Excel 2003, you can have up to three different formats for each cell and the formats can depend on more complex formulas and on the values of other cells, so there are lots of options.


Report •
Related Solutions

Ask Question