Microsoft Office Forums - View Single Post - [Solved] Auto Colors in Cells?

Thread: [Solved] Auto Colors in Cells?

View Single Post

Old

07-04-2010, 09:18 AM

Learner7

Learner7 is offline

Learner7 uses Windows XP

Windows XP Learner7 uses Office 2007

Learner7 uses Office 2007

Office 2007

Advanced Beginner

The original poster

Join Date: May 2010

Posts: 51

Learner7 is on a distinguished road

Default

Auto Colors in Cells?

Hi,

I am using MS Excel 2007. I would like to know whether we can do the following:

If I write 2 in Cell A1, The Cells A2 & B2 to be automatically colored in red (as in the attached image file. If I increase the number in Cell A1 the A2 & B2.......etc. should be colored according to number written in the Cell A1.

Thanks.

Attached Images

Excel_Color.JPG (6.5 KB, 11 views)

Reply With Quote