drom
Well-known Member
- Joined
- Mar 20, 2005
- Messages
- 543
- Office Version
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
Hi and Thanks in advance!
For this eg I can't use the normal conditional formatting, not VBA
I have a huge SumProduct formula on a cell (No problem)
If the result Shows 0, I Am going to put "Wrong"
I can do this using excel's formatcells/Number/Custom like:
Now I would like to put when the formula shows >1 "Wrong" as well
kind of:
I could use the formula on other cell and use a easy formula on the activecell like:
For this eg I can't use the normal conditional formatting, not VBA
I have a huge SumProduct formula on a cell (No problem)
If the result Shows 0, I Am going to put "Wrong"
I can do this using excel's formatcells/Number/Custom like:
- ;;"Wrong";
Now I would like to put when the formula shows >1 "Wrong" as well
kind of:
- [>1] "Wrong";;"Wrong";
I could use the formula on other cell and use a easy formula on the activecell like:
- If(OR(B2=0,B2>1),"Wrong","")