Conditional Formatting with Excel - Part 2

Posted on 2011-02-14
Medium Priority
Last Modified: 2012-08-13
Hello Experts,

You have already helped me immensely with my last request to conditionally format a an excel cell.

I would like to ask a similar request. This time I would be very grateful if someone could me how to conditionally format cell Q2, in the example, so that when it reaches 0.02% the cell will be highlighted green. And should it go back above 0.02/% to go back to white/clear cell?

As always thank you so much


Question by:cpatte7372
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3

Author Comment

ID: 34892920

Should the second part of my request prove a little difficult, I would be happy if you could accomplish the first part of the request.


LVL 50

Accepted Solution

barry houdini earned 2000 total points
ID: 34892979
Hello Carlton,

Select Q2 and then use Conditional formatting > New Rule > Format only cells that contain > and in boxes below select

Cell value > Less than or equal to > in the box type 0.02%

Click "Format" button and choose required format > OK

regards, barry

Author Comment

ID: 34893090

Thats fantastic mate.


Author Closing Comment

ID: 34893113
Cheers mate.

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …

800 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