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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Barry,
Thats fantastic mate.
Cheers
Thats fantastic mate.
Cheers
ASKER
Cheers mate.
ASKER
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