Conditional Formatting of text in excel

Posted on 2011-05-09
Last Modified: 2012-05-11
I have setup a formula:

 =IF(Codes!Q1>0, VALUE(Codes!Q1) & " Errors found", "No Error")

I want to highlight the true part [VALUE(Codes!Q1) & " Errors found"] as red and [No Error] as green once the condition is evaluated. Is that possible?.
Question by:nainil
    LVL 85

    Expert Comment

    by:Rory Archibald
    Yes you can use conditional formatting to change the colour based on the cell value. Which version of excel is it?

    Author Comment

    Excel 2007.

    Expert Comment

    If you have access to you tube... check this out.. this might help you to learn conditional formatting...

    Author Comment

    I know how to use conditional formatting.  However, I am unable to achieve the formatting for text. It is primarily working correctly for numbers only.
    LVL 85

    Accepted Solution

    Home tab- Conditional formatting, highlight cells rules, Equal To..., enter "No error" without quotes, then click the dropdown, choose Custom Format and choose the formatting you want, then OK out of the dialogs.
    Now simply set the default formatting for the cell to Red font so that all other values show as Red.

    Author Closing Comment

    I knew i was missing a small step.
    Appreciate your help.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    This article will show, step by step, how to integrate R code into a R Sweave document
    This is an explanation of a simple data model to help parse a JSON feed
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.
    In this fourth video of the Xpdf series, we discuss and demonstrate the PDFinfo utility, which retrieves the contents of a PDF's Info Dictionary, as well as some other information, including the page count. We show how to isolate the page count in a…

    759 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now