Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Discussion (Misc queries) | |||
Expanding conditional formating with reference cells changing | Excel Discussion (Misc queries) | |||
how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
Is it possible to do a conditional subtotal in Excel? | Excel Worksheet Functions |