View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Ron is offline
external usenet poster
 
Posts: 250
Default Conditional formatting - case sensitive text

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,
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