Function

  • Thread starter Thread starter Billy Joe
  • Start date Start date
B

Billy Joe

I want to use conditional formating. I want a formula to
check three cells to see if they equal Yes, if they do I
want to change the background from white to yellow for
cells range A5 through O5
 
Hi Billy Joe

Mark the range A5:O5
Format=>Conditional Formatting=>Drop down to Select Formula Is
In white pane type =AND($A$1="yes",$A$2"="yes",$A$3="yes")
Choose Fomat=>Patterns and select colour

Change cells A1:A3 to your cell range, but don't forget to use the $'s to
make the references absolute
 
Another way

=COUNTIF($A$1:$A$3,"Yes")=3

also note that you had a quotation too many in the second condition
 
-----Original Message-----
I want to use conditional formating. I want a formula to
check three cells to see if they equal Yes, if they do I
want to change the background from white to yellow for
cells range A5 through O5
.
fuk
Click to expand...
 
Back
Top