mysterious-dr-x
Board Regular
- Joined
- Jul 29, 2011
- Messages
- 51
Please see image below.
Currently the "Signed" cell has conditional formatting using the following formula to make it hatched;
=ISBLANK($O43)
Which was fine, but I now need to add the checkbox (Linked to a cell called "Eng") into the equation. The idea being that if either the reference cell is filled in or the checkbox is ticked, the currently hatched cell becomes blank. I tried...
=OR(ISBLANK($O43),Eng = TRUE)
...but that doesn't seem to work & I am out of ideas. Help?
Currently the "Signed" cell has conditional formatting using the following formula to make it hatched;
=ISBLANK($O43)
Which was fine, but I now need to add the checkbox (Linked to a cell called "Eng") into the equation. The idea being that if either the reference cell is filled in or the checkbox is ticked, the currently hatched cell becomes blank. I tried...
=OR(ISBLANK($O43),Eng = TRUE)
...but that doesn't seem to work & I am out of ideas. Help?