Try Conditional Formatting:

Formula is:
=(E14=1000)+(E14=5000)+(E14=20000)0
and pick the red background


Similar for the small coinage

--
Gary''s Student
gsnu200709


"Anthony" wrote:

Hi,
Cell E14 will contain two sets of numbers
1st set = 1p,10p,20p,30p,£1,£50,£600
2nd set = £1000,£15000,£20000

I want the colour of Cell E14 to be blue, ie
Code:
Selection.Interior.ColorIndex = 41
Selection.Font.ColorIndex = 2

if any of the values is equal to 1st set as above

or

the colour of cell E14 to be red, ie
Code:
Selection.Interior.ColorIndex = 3
Selection.Font.ColorIndex = 2

if any of the values is equal to the 2nd set as above,
Cell E14 will only contain one number at a time from any of the two sets of
numbers.
I just need the cell to be red or blue accordingly depending which number
from which set is chosen
any ideas code/and or formula ??
thanks