Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with Color and a Flare!
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with Color and a Flare!
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with Color and a Flare!
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting with Color and a Flare!
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
conditional formatting-different data to one color | Excel Discussion (Misc queries) | |||
Conditional Formatting on Color | Excel Worksheet Functions | |||
Color Conditional Formatting | Excel Worksheet Functions | |||
Conditional Formatting and Cell Color | Excel Worksheet Functions | |||
Conditional color formatting entries have wild color. | Excel Discussion (Misc queries) |