Conditional Formating

[ToadOnRoll]

Hello,

I'd like to apply the same conditional formatting if the folowing numbers are found in a column 20,47,48 or 53.

Excel only does 3 conditional formats. So is there anyway of using the "or" function in a single conditional format. i.e. = "20" or "47" or "48" or 53"

Or am I just being stupid?

Cheers

 

[SydneyGeek]

If the column is formatted as text then the condition would be

Formula Is =RIGHT(A2,2)="00"

If it's formatted as a number (eg 0000 as a custom format), then try

Formula Is =MOD(A2,100)=0

Denis