How to use the Stop If True Condition for highlight cells

F

Fefe

The Stop If True Condition don't seem to be work when you input an formula to
highlight all cells greater than 100 and Stop If True, once it finds the
first value that that is greater than 100. It highlights all the cells.
 
B

Bob Phillips

Surely, Stop If True is to stop any further conditions being evaluated for
that (each) cell, not stop at the first matching instance.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting - Comparative Versus Other Cells 4
nested IF without repeating the condition? 1
Conditional Formatting - Formula to fill cell using >% 2
Minimum Date Greater than Today() 6
SUMPRODUCT sum until condition changes 1
How to use IF and OR function together 2
highlight the row if meets the condition 5
Highlight MAX Cell Greater Than Zero 4

Top