Follow-up Question?

[Klaatu]

What would be the conditional format argument to say:

"If NOT R, Y, or G, make the cell text bold black and shade the cell white."

Thanks.

 

[Bob Phillips]

=IF(AND(A1<>"R",A1<>"Y",A1<>"G")

and format as required.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)