conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want a cell to be colored if E9,G9,&J9 all have yes entered in, but the
formula I am using does not color the cell.

="if(and($E$9=""yes"",$G$9=""yes,$J$9=yes)"
 
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")
 
The formula:
=IF(AND($E$9="yes",$G$9="yes",$J$9="yes"),1,0)
will yield a 1 or a 0 in the cell where it is located based on the contents
of the three cells listed. If you then go to Format / Conditional Formatting
and make the cell one color if the result is 1 (one condition) or another
color if the result is 0 (a second condition).
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two IF Statements with two answers 3
IF AND Formula Help Needed 7
IF AND OR Formula Help 1
Conditional formating using named cell 1
Quick help with a simple function! 4
Using variable for cell reference 3
Concatenate and empty cell 4
Comparing Time in a Formula 1

Back
Top