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