User Profile
npshibzk
Copper Contributor
Joined 6 years ago
User Widgets
Recent Discussions
Re: How to conditionally format a cell that has two numbers instead of one?
Each cell is a different customer/call. Thank you for looking at this. The above screenshot shows all columns. I highlighted every cell that contains "METER" or "MTR" thus far to help narrow it perhaps. But still would require a lot of work. It is a mess! mathetes5.9KViews0likes4CommentsRe: How to conditionally format a cell that has two numbers instead of one?
Here is a screenshot of the column of "Remarks" where the meter numbers would be documented in. There are over 11,000 rows, which is why I was wondering if there was an easier way to flag cells that have two meter numbers written in them. Also, I apologize, but it appears meter numbers are 7 digits long. mathetes6KViews0likes6CommentsHow to conditionally format a cell that has two numbers instead of one?
Hello all, I have a column that has text with activities that field technicians completed on meters. In this column, they input a meter #. However, sometimes they accidentally could input two meter #'s. I am interested in somehow conditionally formatting this column for each cell, that if they do have two meter #'s somewhere in the paragraph described, that it will flag the cell (color code, etc.). Each meter # is six digits long, so is there a way I could just search each cell, see if there exists two six digit numbers in that cell, and flag it? Or should I search each cell by text (look for "meter" twice in the paragraph, flag it)? Is this even possible?Solved6.2KViews0likes12Comments
Recent Blog Articles
No content to show