Question

Locked

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.

3 total posts (Page 1 of 1)  
| 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

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums