Your explanation doesn't make much sense to me, so it's really a guess as to
what you are trying to do.

Using an IF() in conditional formatting doesn't make much sense. All you
really need to do is enter a formula that evaluates to TRUE or FALSE. That's
usualy the first argument to the IF().

BTW, you can simplify your OR() a little bit by using

OR(O9="",E9={"d","n","na"},H9="pv",RIGHT(J9,2)="du ",RIGHT(M9,2)="du",AI9<$AI$4)

"nastech" wrote:

Hi, thanks for that, not sure if that will work. (you might be right) I
already am using "Formula is" option for where the formula originally came
from, but what trying to do is use what might call the prefix, listed below,
which is the same in all 3 conditional formats.

Aside from that, what need is for each record to "wildcard? the rest of the
9's in that row: I was trying to put line listed below, into 1 single cell.
Would need something like:

=IF($AU$9="T","",.... in conditional format

but all the rest of the 9's to be wildcards? in that single cell. Just
don't know if can do.
=IF(OR(O9="",E9="d",E9="n",E9="na",H9="pv",RIGHT(J 9,2)="du",RIGHT(M9,2)="du",AI9<$AI$4),"T","")

Is that a sort of reverse "mixed reference"? Thanks
xxxxx

"Duke Carey" wrote:

If your question is: 'Can you use mixed reference in Conditional Formatting?'
the answer is yes.

use the 'Formula is' option, then type in

=($AU9="T")

click on the Format button and set the formatting attributes. OK your way
back out to the worksheet


"nastech" wrote:

Can I put the first part of a conditional format in an external cell, and
make reference to it, but have reference go to one "Absolute" Cell? The
first part of the equation is a IF true, then not, idea. Was / am using:

=IF(OR(O9="",E9="d",E9="n",E9="na",H9="pv",RIGHT(J 9,2)="du",RIGHT(M9,2)="du",AI9<$AI$4),"T","")

=IF(AU9="T","",.... in conditional format

Can I have the info in the 1st part referenced to a single cell, and all
other lines refer to it? i.e. line #'s "9" won't be same from every line of
the new origin.
(Need to make the 9 universal). Thanks