I need a way to test is cell S5 = 0 or does not fit the following format TERM-########-####.
if yes then i will apply conditionnal formatting so the cell is red.
In case you need to use another cell as interim formula then i would use AA.
Any help would be greatly appreciated
if yes then i will apply conditionnal formatting so the cell is red.
In case you need to use another cell as interim formula then i would use AA.
Any help would be greatly appreciated