conditional formatting
My experience has been that Excel has this nasty habit of putting
quotes around formulas in Conditional Formatting. I always have to go
back and remove them. Make sure your conditional formatting formula
does not start and end with quotes (as yours currently does) so it
looks like the one that follows. I also modified your formula as
touch: the IF doesn't apply (unless I'm missing something).
=and($E$9="yes",$G$9="yes",$J$9="yes")
|