Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating CF (to identify case/strikethro differences)
In Excel 2003
I am using CF (to change cell colour) to identify differences in cell values. However I would also like to incorporate into the criteria differences in text e.g. upper case / lower case (not font) and/or strikethrough. Any ideas please |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating CF (to identify case/strikethro differences)
I'm not exactly sure what you want for a final condition, but I think the
EXACT function might help you. The EXACT function performs a case-sensitive comparison of two text strings... perhaps it, maybe coupled with the NOT function will help you achieve what you are looking for. I am not sure you can examine "strikethrough text" without a macro. Rick In Excel 2003 I am using CF (to change cell colour) to identify differences in cell values. However I would also like to incorporate into the criteria differences in text e.g. upper case / lower case (not font) and/or strikethrough. Any ideas please |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating CF (to identify case/strikethro differen
Many thanks Rick
Had tried EXACT and it did not appear to work correctly on every ocassion but incorporating NOT has cracked it. Thought "strikethrough" might be a problem without VBA. Ron "Rick Rothstein (MVP - VB)" wrote: I'm not exactly sure what you want for a final condition, but I think the EXACT function might help you. The EXACT function performs a case-sensitive comparison of two text strings... perhaps it, maybe coupled with the NOT function will help you achieve what you are looking for. I am not sure you can examine "strikethrough text" without a macro. Rick In Excel 2003 I am using CF (to change cell colour) to identify differences in cell values. However I would also like to incorporate into the criteria differences in text e.g. upper case / lower case (not font) and/or strikethrough. Any ideas please |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formating CF (to identify case/strikethro differences)
I am not sure you can examine "strikethrough text" without a macro.
You can test for strikethrough using formulas written with XLM macro functions so no VBA is involved. It's a slight kludge compared to a UDF. -- Biff Microsoft Excel MVP "Rick Rothstein (MVP - VB)" wrote in message ... I'm not exactly sure what you want for a final condition, but I think the EXACT function might help you. The EXACT function performs a case-sensitive comparison of two text strings... perhaps it, maybe coupled with the NOT function will help you achieve what you are looking for. I am not sure you can examine "strikethrough text" without a macro. Rick In Excel 2003 I am using CF (to change cell colour) to identify differences in cell values. However I would also like to incorporate into the criteria differences in text e.g. upper case / lower case (not font) and/or strikethrough. Any ideas please |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to identify lower case vs upper case | Excel Worksheet Functions | |||
case sensitive conditional formatting | Excel Worksheet Functions | |||
Conditional formating -identify blank cell | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Select Case Conditional Formatting Sub? | Excel Discussion (Misc queries) |