Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Ok, a slight re-work to my approach. I'm going to simply validate for the
following: In column L each cell will be highlighted red unless it meets this criteria: 1 @ sign. No more, no less. Between 1 and 4 dots/full stops Between 0 and 3 hyphens I'm going to try using the conditional format option and work record a macro from this, hopefully I'll make enough sense of the code in relation to my actions and edit this to suit my needs :) Will post my results. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Format to Highlight the Active Cell | Excel Worksheet Functions | |||
Invalid cell format in Excel | Excel Discussion (Misc queries) | |||
Excel Auto-Format cell to email format | Excel Discussion (Misc queries) | |||
How to Sort Invalid Email Addresses? | New Users to Excel | |||
Conditional Format to highlight blank cell | Excel Worksheet Functions |