Conditional Formatting problem

[irresistible007]

Since Conditinal formating only allows 3 conditions so i tried to play tricky here I put for 1st condition:

Formula is > =OR("L/C not established", "Cancelled", "Amendment Required", "To be booked")

But it isnt giving me the desired results ! why ?

 

[fairwinds]

Hi,

As it is a formula, you need to reference the cell:

=OR(A1="L/C not established",A1="Cancelled",A1="Amendment Required",A1="To be booked")

 

[irresistible007]

Thanks fair winds it worked but i had to use format painter 4 that..... Thanks again