Conditional formatting - case sensitive text
Try this:
=SUMPRODUCT(--(EXACT(Validation_Entries,L28)))
--
Biff
Microsoft Excel MVP
"Ron" wrote in message
...
Luke,
You are getting me close but I'm not sure how to apply it with verfication
against a named list.
What I'm using now is comparing the contents of cell L28 against a list.
Formula Is: =COUNTIF(Validation_Entries,L28)
"Ron" wrote:
Hello all,
I'm 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
|