I would like to apply conditional formatting to highlight cell that contain text (not number), is there a way of doing this?
Conditional formatting for cell that contain text (not number)
51k Views Asked by user3045580 At
3
I would like to apply conditional formatting to highlight cell that contain text (not number), is there a way of doing this?
For your conditional formatting formula, you can use:
=isnumber(0+A1)
assumingA1
is your cell that you are testing.The
0+
bit will attempt to add 0 to the contents of A1, which will convert the contents to a number, even if it's a number stored as text.