Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional formatting - case sensitive text
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
countif function: how to distinguish case/make case sensitive | Excel Worksheet Functions | |||
Case Sensitive LookUps | Excel Worksheet Functions | |||
Case sensitive filter | Excel Worksheet Functions | |||
case sensitive conditional formatting | Excel Worksheet Functions | |||
Case Sensitive w/ IF | Excel Worksheet Functions |