Description:
Create a series of named ranges, say seven cells each corresponding to days of a week and give each named range a name. The first is say, 'fooblock1' and enumerate from there up to 'fooblock7'. Now, based upon the value of each cell in 'fooblock1', you want to apply conditional formatting to the block. As the Conditional Formatting block is written, in the Cell Range section's Range field, you can only enter a cell or range of cells (e.g. C7:C14). 

What would save a lot of time is to list 'fooblock1' in the Range field. Then for each series of named cells (i.g. fooblock2 .. fooblock7) you would enter the named range each time, set the formatting and you are all set.

This use case is applicable to project management with having various cells change color based upon a date value or weekly block over a milestone's timeline. Setting individual cell ranges that appear just as the Range inside of the Manage Conditional Formatting dialog box Conditional Formats field is difficult to parse with a long list. Having the named ranges instead ensures completeness and ease of management. So, seeing something like this:

Range      First Condition
fooblock1  Formula is {formula 1}
fooblock2  Formula is {formula 2}
fooblock3  Formula is {formula 3}
fooblock4  Formula is {formula 4}
fooblock5  Formula is {formula 5}
fooblock6  Formula is {formula 6}
fooblock7  Formula is {formula 7}
...
fooblock13 Formula is {formula 13}

Instead of
Range      First Condition
C7:C14     Formula is {formula 1}
C16:C23    Formula is {formula 2}
C25:C32    Formula is {formula 3}
...
C104:C111  Formula is (formula 13}

Steps to Reproduce:
1. Create a Named Range
2. Select the range
3. Create a new Conditional Formatting -> Manage -> Add -> Condition 1 -> change to "Formula is"
4. Cell Range -> enter the text string for the named range
5. Observe the Range field turns red and the OK button is grayed-out

Actual Results:
What I would prefer is in this field, to accept beyond a cell range, is to be able to enter the named range value, or a combination of cell ranges and named ranges
c3:c7,JAN24,NAMED_RANGE2,c250:c252
-or-
NAMED_RANGE2,JAN24
-or-
c3:c7,c250:c252 -> which is what is currently permitted.

Expected Results:
To be able to permit entering the a named range instead of a cell range


Reproducible: Always


User Profile Reset: No

Additional Info:
Permitted the named range value along with or instead of a cell range.