Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
CONDITIONAL FORMATTING
Any formula, for how to have a wrong name be highlighted if it doesn't
pertain to a list of 50 different branches? List is already made up in sheet2 and the array being named "Branches". Except Data validation check of LIST. One can after all paste value in case of a data validation too. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
CONDITIONAL FORMATTING
The bad news is that copy|paste will remove the format|conditional formatting as
well as the data|validation rules. Maybe you could tell the users to stay away from pasting--or you could use an adjacent cell: =if(countif(Branches,a2)0,"","Error--Not on list") and give it a nice bold red format. FARAZ QURESHI wrote: Any formula, for how to have a wrong name be highlighted if it doesn't pertain to a list of 50 different branches? List is already made up in sheet2 and the array being named "Branches". Except Data validation check of LIST. One can after all paste value in case of a data validation too. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
sorting a range with conditional formatting | Excel Worksheet Functions | |||
conditional formatting glitches | Excel Discussion (Misc queries) | |||
Keeping conditional formatting when sorting | Excel Discussion (Misc queries) | |||
conditional formatting | Excel Discussion (Misc queries) | |||
cannot use ISEVEN or ISODD functions in Conditional Formatting | Excel Worksheet Functions |