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

Word macro that can call cells out of Excel for a find and replace 0
Subtracting two cell dates and highlight if over due by a certain amount of days 0
Using FIND to highlight text (with dashes) 4
Conditional Formatting - Comparative Versus Other Cells 4
nested IF without repeating the condition? 1
Optionbutton Not working 3
SUMPRODUCT sum until condition changes 1
Installing/purchasing office 2021 plus. A licence question. 0

Top