Feed2Mail notification - new post on Excel IT Pro Discussions Forum
Conditional formatting using named cell in Excel 2010
Greetings,
I want to use a named cell in my Conditional Formatting rule. Let's call it "red_target".
I want to be able to tell the rule, "If cell value is greater than red_target, turn red."
When I type "=red_target" or "red_target" in the Value: field, it thinks I literally mean the string "red_target."
When I use the picker to navigate to that specific cell, it doesn't fill in the name. It uses the R1C1 absolute reference.
Any ideas on using named cells in Conditional Formatting rules?
Thanks,
Rachel
