i will have a colum that requires a yes(Y) or no (N) answer . every time i i
write (Y) for eg in a cell i would like that cell to be blue, and red for (N)
how do i do this . help would be much appreciated. thanks

Use conditional formatting.
Look up 'Highlight cells that meet specific conditions' in the Answer
wizard in help


--

HTH

RP
(remove nothere from the email address if mailing direct)


"mooieblue" wrote in message
...
i will have a colum that requires a yes(Y) or no (N) answer . every time i
i
write (Y) for eg in a cell i would like that cell to be blue, and red for
(N)
how do i do this . help would be much appreciated. thanks

thanks bob i will give it a go

"Bob Phillips" wrote:

Use conditional formatting.
Look up 'Highlight cells that meet specific conditions' in the Answer
wizard in help


--

HTH

RP
(remove nothere from the email address if mailing direct)


"mooieblue" wrote in message
...
i will have a colum that requires a yes(Y) or no (N) answer . every time i
i
write (Y) for eg in a cell i would like that cell to be blue, and red for
(N)
how do i do this . help would be much appreciated. thanks

To see how to use conditional formatting you can look at
http://www.auditexcel.co.za/othertools.html

"mooieblue" wrote:

i will have a colum that requires a yes(Y) or no (N) answer . every time i i
write (Y) for eg in a cell i would like that cell to be blue, and red for (N)
how do i do this . help would be much appreciated. thanks