Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting when text is contained in a named range
I have a workbook in which sheet 1 contains employee assignments for the
upcoming week. Sheet 2 contains several dynamic named ranges. I have one for each project manager in the firm with a list of the projects currently assigned to them. I want to create conditional formatting rules to change the cells on sheet 1 if data is contained in one of the named ranges. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting when text is contained in a named range
Hello Hugh,
Use a formula in the Conditional format to count the cells in the named range that have data in them. If greater than zero then at least one cell has data. Example assumes Manager1 is a named range. =COUNTIF(Manager1,"""") 0 -- Regards, OssieMac "Hugh" wrote: I have a workbook in which sheet 1 contains employee assignments for the upcoming week. Sheet 2 contains several dynamic named ranges. I have one for each project manager in the firm with a list of the projects currently assigned to them. I want to create conditional formatting rules to change the cells on sheet 1 if data is contained in one of the named ranges. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional formatting when text is contained in a named range
Thanks, that did the trick.
"OssieMac" wrote: Hello Hugh, Use a formula in the Conditional format to count the cells in the named range that have data in them. If greater than zero then at least one cell has data. Example assumes Manager1 is a named range. =COUNTIF(Manager1,"""") 0 -- Regards, OssieMac "Hugh" wrote: I have a workbook in which sheet 1 contains employee assignments for the upcoming week. Sheet 2 contains several dynamic named ranges. I have one for each project manager in the firm with a list of the projects currently assigned to them. I want to create conditional formatting rules to change the cells on sheet 1 if data is contained in one of the named ranges. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting 'Named Range' dilemma | Excel Worksheet Functions | |||
Conditional Formatting - 2 Worksheets one Named Range | Excel Worksheet Functions | |||
How do you Identify text as a named range in excel | Excel Discussion (Misc queries) | |||
Conditional formatting if value in cell is found in a named range | Excel Worksheet Functions | |||
Conditional formatting on named text field | Excel Discussion (Misc queries) |