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

Hi Dan

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


--
Regards
Roger Govier

"Dan the Man" <(E-Mail Removed)> wrote in message
news:6277DC55-3290-456E-A800-(E-Mail Removed)...
>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

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" wrote:

> 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

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

Dan

"JLatham" wrote:

> 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" wrote:
>
> > 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