Conditional Highlighting for numbers within a text

I've an excel contact sheet with thousands of images that contains a column with dimensions. The sheet is produced automatically by a plugin in Lightroom, and outputs dimensions for each image as "00...

excel

Formulas and Functions

Savia
Feb 27, 2020
It's pretty complicated, but try this custom rule (replacing B2 with the active cell):

=OR(1*LEFT(B2,SEARCH("x",B2)-2)<1000,1*MID(B2,SEARCH("x",B2)+2,100)<1000)

Savia

Iron Contributor

Feb 27, 2020

It's pretty complicated, but try this custom rule (replacing B2 with the active cell):

=OR(1*LEFT(B2,SEARCH("x",B2)-2)<1000,1*MID(B2,SEARCH("x",B2)+2,100)<1000)

bshfrd
Copper Contributor
Feb 27, 2020
Thank you Savia, this is perfect!

Forum Discussion

Conditional Highlighting for numbers within a text

Resources