Forum menu
Topic starter
Id like to format a cell so that if another cell contains text the cell is green and says "yes" and if impty red and "no". Help
Posted : 21/10/2016 8:44 pm
Super easy!
For the yes/no just use an IF statement. For the colouring use conditional formatting. Takes a couple of mins.
Posted : 21/10/2016 8:53 pm
Topic starter
I can do each bit individually but collectively
So say I put something in F5 I want F7 to then be green and say "yes"
I can get it to change colour but not add text too.
Posted : 21/10/2016 9:22 pm
Never used it, but can't you combine IF and AND functions ?
Posted : 21/10/2016 9:24 pm
In the conditional formatting menus there's a drop down where you can make the condition a formula. Only trouble is it doesn't paste to other rows correctly, a known bug apparently. The more I use Google drive and its apps the more shortcomings I find
Posted : 21/10/2016 9:39 pm