Conditional Formating in Excel

  • Thread starter Thread starter mzafar
  • Start date Start date
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
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Problem 2
EXCEL 2003 - Conditional Formatting 2
conditional formating dates, please help me 1
Partial Shading in Excel 2003 4
Condition formula 2
Conditional Formatting of a row 6
Conditional Formatting- adding more than 3 conditions 6
Add a new row in Named Table (Table1) and add data from txtboxes into last empty cells based on header named of the Table1 0

Back
Top