| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Highlight cells where the last charcter in the cell is a blank
Hi All,
If anyone knows the answer to this one without putting themselves out, I would be very grateful. I have a load of entries in column A (A1:A2000) and some of the cells contain a blank character at the end. Just wondering if those cells with a blank character as the last character can be highlighted by running a formula or macro? Many thanks in advance, Cheers, Pat |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| conditional formatting:highlight row based on blank or non-blank c | Excel Worksheet Functions | |||
| formula in excel that will highlight a cell that is left blank? | Excel Worksheet Functions | |||
| conditional formatting:highlight row based on blank or non-blank c | Excel Discussion (Misc queries) | |||
| Conditional Format to highlight blank cell | Excel Worksheet Functions | |||
| Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
![Pat[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
