Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


conditional formatting of an excel cell

Posted on 2012-09-05
Medium Priority
Last Modified: 2012-09-06

I have excel worksheet and cell value change as "Delayed", "On Time" , I want to set conditional formatting the cell while the contain the string "Delayed" the cell pattern will be red and while its contain "On Time" the cell pattern will be green color.
Please advice how to set the formula to do that.

Question by:alam747
  • 3

Accepted Solution

timmyt851 earned 2000 total points
ID: 38370975
Which version of Excel?

In 2003 and below,
Select the cell, go to Format, Conditional Formatting.
For Condition 1, "Cell Value", "Equal to", ="Delayed", select Red from the font color.
Click Add >>
For Condition 2, "Cell Value", "Equal to", ="On Time", select Green from the font color.

In 2007 and up,
Select the cell and go to Conditional Formatting, select New Rule
Select "Format only cells that contain"
then select "Cell Value", "Equal to", ="Delayed", select Red from the font color.
Hit OK then go back to Conditional Formatting and add another rule.
Same thing but ="On Time" and select Green from the font color.

Author Comment

ID: 38371717
Hi timmy851,

I am using office 2003 and I did as you mentioned but its not working, nothing change.

Please let me know why its not working and how to fix it.


Author Comment

ID: 38374675
Hi timmy851,

Its my mistake, there was space before the string thats why it was not working.


Author Closing Comment

ID: 38374677
Thanks a lot.

Featured Post

Hire Technology Freelancers with Gigs

Work with freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely, and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

With its various features, Office 365 can not only help you with your day-to-day business tasks, it can also do wonders for your marketing campaign.
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

564 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question