| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Conditional Formatting based on Formula
Here is my current formula:
=SUMPRODUCT((Commissions!$J$2:$J$1946=$A31)*(Commi ssions!$B$2:$B$1946='Pay Day'!$A$2)*(Commissions!$B$2:$B$1946<='Pay Day'!$B$2),Commissions!$G$2:$G$1946)*'Pay Day'!$B$31 I want to be able to turn the cell color RED if the final clause equals *'Pay Day'!$B$32. If i over-ride my current formula above with the new ending how can I change my cell color? Any help is greatly appreciated. Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| =IF Statement formula or conditional formatting | Excel Worksheet Functions | |||
| Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting based on if statement. | Excel Worksheet Functions | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
| How do I do conditional format based on a cell with a formula? | Excel Worksheet Functions | |||
Threaded Mode
