conditional formatting

Originally Posted by flipper

I have cells with combinations of the letters N and Y eg. NNYN, YYNY, YNYN, etc. Can anyone suggest how I can conditionally format the cells to show all Y's in each cell in red and the same for all N's in green, eg YYNN.
Thanks

its not possible with Conditional formatting.
however you can use four columns to enter above combinations and apply Conditional formatting on those columns.
see the file attached.