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