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