Conditional Formating in Excel
 

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 column
status based on what's in the cell. For example red for modified, green
for in progress?

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

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

Can you please help?

Regards,
John


--
mzafar
------------------------------------------------------------------------
mzafar's Profile: http://www.excelforum.com/member.php...o&userid=16096
View this thread: http://www.excelforum.com/showthread...hreadid=381965

Yes.

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

etc.

--
HTH

Bob Phillips

"mzafar" wrote in
message ...

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 column
status based on what's in the cell. For example red for modified, green
for in progress?

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

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

Can you please help?

Regards,
John


--
mzafar
------------------------------------------------------------------------
mzafar's Profile:
http://www.excelforum.com/member.php...o&userid=16096
View this thread: http://www.excelforum.com/showthread...hreadid=381965