Color of cells to change

[sushil10s]

Hi

If I enter "Y" color of cell to be changed to green without "Y" being visible

Vice-versa If "N" is entered Red color and ""N" not visible.


Thanks in advance.

[FDibbins]

take a look at conditional formatting, use "new rule" and play around with font and fill colors

if you still have a problem, upload a sample and i will walk you through it

[sushil10s]

Its solved.

Thanks

[FDibbins]

you'r welcome. If this answered your question, please take a moment to mark the thread as "solved" - it helps keep things neat and tidy lol, and consider adding the reputation to those that helped (see points 2 & 3 below)