Conditional Formatting problem

irresistible007

Board Regular
Joined
Nov 24, 2005
Messages
173
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 ?
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
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")
 

Watch MrExcel Video

Forum statistics

Threads
1,118,284
Messages
5,571,307
Members
412,381
Latest member
RogerL
Top