conditional formatting, bleh
On Wednesday, January 4, 2017 at 10:59:28 AM UTC-7, Matthew Dyer wrote:
On Wednesday, January 4, 2017 at 10:28:30 AM UTC-7, Claus Busch wrote:
Hi Matthew,
Am Wed, 4 Jan 2017 09:11:47 -0800 (PST) schrieb Matthew Dyer:
so I must be doing something wrong - when I copy/paste your formula directly into CF I get an broken formula error. I take out the = and hit OK, it puts it back in, and surrounds the formula with "s
in CF you cannot use sheet scope names. Is you name a global name, a
workbook scope name?
Regards
Claus B.
--
Windows10
Office 2016
workbook scope - it's a table name
for the immediate I just hard-coded my range (H2:H20), but I would appreciate if someone could tell me how I could use my named range instead.
|