| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditional formatting
Hi all
Is there a conditional format that you can format to allow a cell only to accept the words USA or GB or CANADA or EUROPE. All others would leave the cell blank? Thanks Stew |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting
Hi,
You could use data validation. Create a list of your names somewhere out of the way then select your cell Data|Validation Select list Enter the range that contains your list in the input box OK Mike "stew" wrote: Hi all Is there a conditional format that you can format to allow a cell only to accept the words USA or GB or CANADA or EUROPE. All others would leave the cell blank? Thanks Stew |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
conditional formatting
Brilliant. You learn every day. Thanks
"Mike H" wrote: Hi, You could use data validation. Create a list of your names somewhere out of the way then select your cell Data|Validation Select list Enter the range that contains your list in the input box OK Mike "stew" wrote: Hi all Is there a conditional format that you can format to allow a cell only to accept the words USA or GB or CANADA or EUROPE. All others would leave the cell blank? Thanks Stew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
