Firstly, just a quick one:
I want to use conditional formatting to check if a cell ( say A1) has a red background and if it does then report "yes" or "red" into the next cell (say B1).
Secondly, I am comparing to columns of data using :
=ISNA(MATCH(A45,$B$10:$B$5902,FALSE)) but striking probables as it shows an incorrect TRUE (which is not a match). The cell A45 does in fact have a match in B10:B5902, but the cell format is CATEGORY: Special TYPE: Numer Pesel LOCALE: Polish
My number is 11 digits long and has leading zero's. Because of the above cell format it appears it doesn't compare right. I've tried changing the format to NUMBERS,GENERAL, or CUSTOM (for 11 zero's), but it always reverts back to this "Numer Pesel" ???
I've tried using the LEFT command to chop of one of the leading zero's as the format can be changed to GENERAL or NUMBER and not revert back. This leads to another problem where
the LEFT command could change some numbers without a leading zero and therefore appears that it exists as the remaining numbers are the same except for that leading zero.