| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
excel fields - validation
How can I use excel formula to force an entry to be input to Field B, if
Field A has certain value ? Thanks. Regards. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
excel fields - validation
Use conditional formatting to turn the Field B red if A has a value and B is
empty. Eg: =AND($A$1<"",$B$1="") Assuming you mean on a sheet - you don't specify. Tim "magix" wrote in message ... How can I use excel formula to force an entry to be input to Field B, if Field A has certain value ? Thanks. Regards. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
| Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
| Data validation with several fields | Excel Programming | |||
| Catalogue of fields' connection whit external fields ( sheets) | Excel Programming | |||
| Catalogue of fields' connection whit external fields ( sheets) | Excel Programming | |||
Linear Mode
