Conditional Formatting

[sighlent1]

Hey,

For using Conditional Formatting, I'm looking for a formula to format cell A1:

Blank, 5, 10 or 15 - Original Format
Any other value - Format Change

Thank you
Bob

[zbor]

You can try this: =OR(ISBLANK(A1),A1=5,A1=10,A1=15)

[zbor]

And this for reverse format: =NOT(OR(ISBLANK(A1),A1=5,A1=10,A1=15))

[NBVC]

Try

=AND(A1<>"",A1<>5,A1<>10,A1<>15)

[sighlent1]

Excellent, Thank you guys soooo much....That is EXACTLY what I'm looking for

Thank you and I appreciate your time
Bob