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?
