HardAtWork
Board Regular
- Joined
- Sep 17, 2010
- Messages
- 52
I'm working on conditional formatting in a program file. This is the original code.
If(Errorchecking=False,True,If(Page1=1,If(ISBLANK($K$37),If(ISBLANK$K$39,False,True),If(ISBLANK($K$39),ISBLANK(F30),False)),True))
This statement when true makes the font color black. The above coding works great!
HOWEVER, I need the Errorchecking to be equal to true not false (due to other coding I have put into the file)
After the errorchecking is made true then the font color will be red
If I split the original coding up into two section I can make it work, but I can't figure it out when put together. Can anyone help?
If(Errorchecking=False,True,If(Page1=1,If(ISBLANK($K$37),If(ISBLANK$K$39,False,True),If(ISBLANK($K$39),ISBLANK(F30),False)),True))
This statement when true makes the font color black. The above coding works great!
HOWEVER, I need the Errorchecking to be equal to true not false (due to other coding I have put into the file)
After the errorchecking is made true then the font color will be red
If I split the original coding up into two section I can make it work, but I can't figure it out when put together. Can anyone help?
