Conditional formatting - case sensitive text

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

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
 
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.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIFS help 3
Using Dates in Conditional Formatting 9
filtering to separate upper & lower case 5
Conditional Formatting Confusion 8
Case Sensitivity in Lookup Functions 4
If a cell = TRUE how do I get the cell to do a sum function 4
Case sensitive filter 3
Comparison of columns using Conditional Formatting 3

Back
Top