K kelleyz3 May 26, 2004 #1 How would I set it up where a data in a cell would be red unless it wa equal to N, O or P
F Frank Kabel May 26, 2004 #2 Hi use the following formula in the conditional format dialog: =AND(A1<>"N",A1<>"O",A1<>"P")