hi Claire, the $ sign matters. in case you have done any steps wrong, i'll go through the whole process. select the range you want to apply to (eg E3:F10)
go to Home -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
this means that in E3, it compares E3 & F3. it then copies the formula over to F3. but because i use the dollar signs, it still compares column E & F. your formula would cause it to become:
=AND(F3=”Yes”, G3 =”Yes”)
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."