I have this rule
Attachment 185691
and I expected only cell X8 to be blue but this is the result. What am I doing wrong?
Attachment 185692
Printable View
I have this rule
Attachment 185691
and I expected only cell X8 to be blue but this is the result. What am I doing wrong?
Attachment 185692
Try the attached test file.
Thanks. I don't know what I'm doing wrong but after I enter $X$2 for the cell value Excel puts single quotes around it.
Attachment 185695
Nevermind, I figured it out. Thanks again.