> than < than change cell to red (MS Excel)

Posted on 2005-05-09
Last Modified: 2010-04-17
Afternoon all. Ok, I have a daily sales column 'J4' and a stock figure in 'H4' If the daily sales is lower than the stock figure. I want the cell to change to red. There will be a second part to this question, but I need to do one step at a time. Many thanks for your help all. Lee.
Question by:helponaccess
    LVL 13

    Expert Comment


    Author Comment

    Thanks Softplus.

    I am pretty thick when it comes to this stuff. (still learning). So please bare with me.
    I have had a look at the above link, and i am still none the wiser.

    Could you make the answer as simple as possible?

    LVL 13

    Accepted Solution

    I don't have the english Excel, but I'll try (with help of the above link for the english terms) :)
    To add conditional formatting to a cell select the cell you want to format.
    Choose the menu Format->Conditional Formatting...
    Change the dropdown from "Cell Value Is" to "Formula Is" and enter the formula (i.e. J4<H4).
    Click "Format" and then the Pattern tab. Choose a color. You can add multiple conditions for the same cell by clicking the Add>>. Each condition can have a unique format. Click OK and OK again.

    Does that work?

    Featured Post

    Free Trending Threat Insights Every Day

    Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

    Join & Write a Comment

    Suggested Solutions

    Go is an acronym of golang, is a programming language developed Google in 2007. Go is a new language that is mostly in the C family, with significant input from Pascal/Modula/Oberon family. Hence Go arisen as low-level language with fast compilation…
    Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
    An introduction to basic programming syntax in Java by creating a simple program. Viewers can follow the tutorial as they create their first class in Java. Definitions and explanations about each element are given to help prepare viewers for future …
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    729 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

    17 Experts available now in Live!

    Get 1:1 Help Now