Microsoft Office Forums - View Single Post - [Solved] VBA highlight if value less than 10

Thread: [Solved] VBA highlight if value less than 10

View Single Post

Old

02-28-2024, 01:33 AM

Shelley Lou Shelley Lou is offline

Shelley Lou is offline

Shelley Lou uses Windows 10

Windows 10 Shelley Lou uses Office 2016

Shelley Lou uses Office 2016

Office 2016

Expert

The original poster

Join Date: Dec 2020

Posts: 259

Shelley Lou is on a distinguished road

Default

VBA highlight if value less than 10

Hi Vivka, the second option seems to work which I changed to accommodate non breaking spaces also. Many thanks for responding.

Code:

.text = "<[0-9][ ^s]" & Split(StrFndB, ",")(i)

Reply With Quote