View Single Post
 
Old 02-11-2019, 07:00 PM
Marcia's Avatar
Marcia Marcia is offline Windows 7 32bit Office 2007
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
I was thinking what if we use just one criteria which is more stable that is the oracle numbers?
I edited NBVC's formula, removing the name in the criteria so It's just the Oracle numbers. You will notice the cells with colored background caused by the conditional formatting. You type the correct oracle and registration numbers. I intentionally typed numbers in those cells to check if the CFs are working.
I deleted the columns with no data and several rows at the bottom in order to meet the limit of not more than 500 kb.
Attached Files
File Type: xls DATA1.ORACLE.xls (498.0 KB, 9 views)
Reply With Quote