Set cell colour - if numbers exist in a list

[Asrampd]

Each cell on my sheet has two numbers either side a "|" charactor (e.g. 5|123)

I am looking for a Macro that processes the range on sheet "Main" A1:C19 and sets each cell colour (say to Red), if the numbers don't appear in both Columns C & D

Listpoint

	A	B	C	D
1	MNEMONIC	OSN	PNT	TYP
2	===============	===	===	===
3	01A0003	1	31	CMD
4	01A0001	1	102	CMD
5	10004	1	128	PRG
6	01R2601	1	17	CMD
7	01A0TIM	1	106	TIM
8	01P0108	1	74	AI

<COLGROUP> <COL style="WIDTH: 30px; FONT-WEIGHT: bold"><COL style="WIDTH: 129px"><COL style="WIDTH: 35px"><COL style="WIDTH: 32px"><COL style="WIDTH: 36px"> </COLGROUP><TBODY>
</TBODY>

Excel tables to the web >> Excel Jeanie HTML 4


So that -

1|31, would be Ok
1|32 would be RED
1|102, would be Ok
1|128, would be Ok
etc.


The file is available at
https://www.dropbox.com/s/ow9j49y19bhi0wc/Book7_1.xlsm

Ta.

 

[MrBill11]

Asrampd,
This is not a macro, but it might help?
If you added a helper column (E) you could use this formula =iferror(if(find(b3:c3),"Yes",""),""). Then use this formula for conditional formatting for cells b3 & c3 =AND($E$3=""), set color to red.

<colgroup><col></colgroup><tbody>
</tbody>

 

[Asrampd]

Thanks for the reply, I don't know if you saw the Workbook, it checks for the existance of the number sequence, e.g. 101|23 (on a different sheet) in two columns.

Ta.