Solved: Highlight Numbers

[nicolaforni]

I have a series of numbers in column B from B10 to B20. I would like to create a VBA Loop that highlights in red all the numbers 2 in column for as long as there are numbers to check. Thanks! :help

[stanleydgrom]

nicolaforni

You can use Conditional Formatting.

Highlite range B10:B20
Click on "Format", "Conditional Formatting…"
Condition1, drop down box, "Cell Value Is"
Next drop down box to the right, "equal to"
Next drop to the right, enter a 2
Then click on the "Format" button.
Click on the "Pattern" tab, and click on the red color
Click "OK, and the click "OK"


Have a great day,
Stan