I've used the 3 conditioning formats but would like to be able to add a
couple more.
What i would like to be able to do is when i enter a letter or number into a
cell it changes colour but still shows the letter or number.
Is there a formula that allows me to do this or do i need to use a macro if
so what do i need to do.
All help is greatly appreciated