Conditional formatting - case sensitive text
Conditional format, formula is:
=EXACT(B2,A:A)
would check to see if the value in B2 has an exact (case-sensitive) match in
column A. Copy formatting down to other cells as desired.
--
Best Regards,
Luke M
*Remember to click "yes" if this post helped you!*
"Ron" wrote:
Hello all,
Im verifying one column of data to another using conditional formatting. It
works fine except I need to perform this based on case sensitive text. Anyone
know of a way to accomplish this?
Thanks,
RB
|