Formatting of acell

Hi All

Just wondering is it possible to format a cell based on the value in that cell

for example

Format cell A1 to ;;;"N" if the value in A1 is N1 or N2 or 1N or 2N
Or format cell A1 to ;;;"R" if the value in A1 is R or r

Thanks in advance

Hi

Thanksfor that, going to try it now

I know a little about VBA, i have tried some code to do this but not sure if it is ok as yet will post in soon

if anyone could post some code that will work it would be very much appreciated

thanksin advance