Software

Ask something
Question Locked

Excel formatting....

0 helpful
3 replies

by tmalo627

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello all,

I am using Excel 2007. I have been asked to make a spreadsheet with what projects I am currently working on. This table will have a status column to show how far along on each project I am. I would like to be able to format the background color of an entire row based on the status column. So if I enter "complete" into the status column the entire row changes to green, or "in progress" to yellow, etc.

Can anyone help?

3 replies

by Member 25348569

Excel's "Conditional Formatting" function - which you'll find in the "Format" menu - will change the row colour for up to three entries.

Otherwise, you'll need a bit of VBA.

How many colours do you want?

by tmalo627

I just had to make sure that the correct range of cells was entered in the appropriate box in the formulas rule.

Thank you

This discussion is closed to new replies.