Hi Dan

Select AH4:AH3500
FormatConditional FormattingCell value isEqualsSend IDIP 036 to DPHS
Choose Format required


--
Regards
Roger Govier

"Dan the Man" wrote in message
...
I have the following formula written into cells AH4:AH3500 and it works
PERFECTLY. If possible, I'd like to use "conditional formatting" in cells
AH4:AH3500 to turn the cell "yellow" when the following flag (form the
formula below) pops up: "Send IDIP 036 to DPHS":

=IF(AND(Z4<"",AN4="Referred to
TX"),(IF(TODAY()AF4,(IF(AI4="Sent","$50.00
Owed-File Closed!",(IF(AI4="$50.00 Admin Fee Paid","",(IF(AI4="IDIP 036
Rescinded","","Send IDIP 036 to DPHS")))))),"")),"")

Is this possible?

Dan