• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 193
  • Last Modified:

Conditional Formatting with Excel - Part 2

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

Cheers

Carlton
format-cell.xlsx
0
cpatte7372
Asked:
cpatte7372
  • 3
1 Solution
 
cpatte7372Author Commented:
Experts,

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.

Cheers

Carlton
0
 
barry houdiniCommented:
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
0
 
cpatte7372Author Commented:
Barry,

Thats fantastic mate.

Cheers
0
 
cpatte7372Author Commented:
Cheers mate.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now