Hi,

I am trying to change the colour of a cell based on a lookup.

So i one line of 6 numbers, i.e 1,2,3,4,5,6. On another sheet i have a range of numbers that could contain any of the above.
If the number appears in the range i want to higlight the cell a colour.
I've written this formula adjacent to the single line which works if i want to show an "X" character if the number is found but i really want to change the colour of the cell only so i can still see the number.


=IF(COUNTIF('LookupRange'!$A$1:$G$100,'2008'!B7)>0,"X",'SingleLine'!A1)
I did this in vba but someone managed to delete it for me which was nice. I'm hoping there is a quick way to achieve this in a formula so i don't have to write the code again.

Many Thanks