| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel, Marking a field when text is not like required
you could use Conditional Format on A2.A999
use 'formula is' and =NOT(OR(A8="aaa",A8="bbb",A8="ccc")) set a pattern color as required Patrick Molloy " wrote: Hello, I like to have a module which marks the datafield, in column A from record 2 till last, in color red when the registered data is not equal to "aaa" or "bbb" or "ccc". Can you help me out. Johan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked excel field from access form field - help required. | Excel Programming | |||
| can I make a field in excel spreadsheet required? If yes, How? | Excel Discussion (Misc queries) | |||
| In Excel, how to make a field required so it's not left blank? | Excel Programming | |||
| Required field message - Excel | Excel Discussion (Misc queries) | |||
| Field Required if another field is checked | Excel Programming | |||
![Patrick Molloy[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
