excel - Can I use a named range cell value as a formula in Conditional Formatting - Stack Overflow

admin管理员组

文章数量:1122832

I have an Excel where, for user ease, I'd like to put the conditional formatting (CF) formulas in the spreadsheet itself, and give the cell a name. Then use that single-cell range in the CF.

The affected range in the CF would be great too but if I put a range in the CF affected area field, it reverts back to cell-coordinates.

My overall goal is to replace all cell sticky coordinates with named ranges. My users are not that savvy with Excel, neither am I honestly, but adoption of this thing I'm working will be greatly enhanced if users can work with words and not cell-references.

Thank you in advance.

I've attached two screenshots I think will explain it better.

I have an Excel where, for user ease, I'd like to put the conditional formatting (CF) formulas in the spreadsheet itself, and give the cell a name. Then use that single-cell range in the CF.

The affected range in the CF would be great too but if I put a range in the CF affected area field, it reverts back to cell-coordinates.

My overall goal is to replace all cell sticky coordinates with named ranges. My users are not that savvy with Excel, neither am I honestly, but adoption of this thing I'm working will be greatly enhanced if users can work with words and not cell-references.

Thank you in advance.

I've attached two screenshots I think will explain it better.

• excel
• excel-formula
• conditional-formatting

Share Improve this question Follow edited Nov 21, 2024 at 17:57 Scott Craner 152k1010 gold badges5151 silver badges8585 bronze badges asked Nov 21, 2024 at 17:39 DavidsonDavidson 1,09633 gold badges2222 silver badges3737 bronze badges 3

• 11 This is not a Google Sheets question; the Sheets tag clearly says Do NOT use with [excel]. For some reason you keep re-adding the tag even after its edited out! – rockinfreakshow Commented Nov 21, 2024 at 17:51
• Im sorry. I was in a hurry, and saw this tag on another similar question. I'm a stupid freak. If I can remove it, I will. – Davidson Commented Nov 21, 2024 at 18:06
• Cool... the tags are corrected now – rockinfreakshow Commented Nov 21, 2024 at 18:12

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 2

Use INDIRECT:

=INDIRECT("Description_Error")

And correct there is no way to make the applies to refer to a named range or even a structured reference. It will be converted to an actual range reference.

本文标签： excelCan I use a named range cell value as a formula in Conditional FormattingStack Overflow