Excel formatting....

By tmalo627 ·
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?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

If you only want three colours

by neilb@uk In reply to Excel formatting....

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?

Collapse -

I've got it...

by tmalo627 In reply to If you only want three co ...

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

Thank you

Related Discussions

Related Forums