Conditional Formatting with Color and a Flare!

[Dan the Man]

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

 

[Roger Govier]

Hi Dan

Select AH4:AH3500
Format>Conditional Formatting>Cell value is>Equals>Send IDIP 036 to DPHS
Choose Format required

 

[JLatham]

Where is that formula at? In just one cell, or is it already in AH4:AH3500?

If that formula (or variation of it) is already in AH4:AH3500, then setting
conditional formatting is as simple as selecting that range and going into
conditional formatting and choosing Cell Value Is and then Equal To and
typing in Send IDIP 036 to DPHS as the value it needs to be equal to, and
then setting the shading.

If that formula is in one cell, then again choose AH4:AH3500 and go into
conditional formatting but this time use Formula Is and type in
=$X$99="Send IDIP 036 to DPHS"
change $X$99 to the address of the cell where your formula is at, of course,
and then set the shading for the cells.

 

[Dan the Man]

Thanks gentleman! That did the trick (the values were in AH4:AH3500).

Dan