Conditional Formatting based on Formula

[Pete Petersen]

Here is my current formula:
=SUMPRODUCT((Commissions!$J$2:$J$1946=$A31)*(Commissions!$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

 

[Ola]

Are you looking for
a) the formula string: *'Pay Day'!$B$32 or
b) the value: ='Pay Day'!$B$32 ?

If it's the string:
Install the MoreFunc (Add-in functions) --- http://longre.free.fr/english/
Use the function =FORMULATEXT(..) and find RIGHT(..,16)

If it's the value: Conditional Format just change Condition 1 'Cell Value
Is' to ' Formula Is'

Ola Sandstrom