| 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 |
| 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) | |||
![Dan the Man[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
