Conditional Formating in Excel

M

mzafar

I have four columns in my spreadsheet

DB Name Job ID Status Comments
Test 1 In Progress None
Test1 2 Checked None
Test3 3 Modified None

The question I have is, can I setup excel to change the color of colum
status based on what's in the cell. For example red for modified, gree
for in progress?

Also, is it possible to change the color of the entire row for the jo
that has status "modified"?

I have data validation set for Status column so anything that entere
besides the values listed above is invalid.

Can you please help?

Regards,
Joh
 
B

Bob Phillips

Yes.

Select the whole row, say 2
Menu Format>Conditional Formatting
Change Condition1 to Formula Is
Add a formula of =$C1="Modified"
Click fomat
selec t the Pattersn tab
Choose Colour
OK out

etc.
 
Top