Goh Hock Siew
New Member
- Joined
- Jun 2, 2011
- Messages
- 1
Dear Sir,
I tried to use the Get.Cell BUT the Excel 2003 does not seem to know it exist.
I tried the above example from your book Excel Gurus Gone Wild but they do not work.
To highlight every cell that does not contain a formula , use =NOT(hasFormula) in the conditional formatting.
1. First I go ti define Name
2. Enter Names in Workbook HasFormula
3. Then go to Refers to : and entered =GET.CELL(48,INDIRECRT("RC",FALSE))
4. Then I select a range of sells
5. Select Format, Conditional Formatting, Change the first dropdown to Formula is Type = HASFORMULA and then click OK
5. Then I tried the formula =NOT(hasFormula) in the conditional formatting but it does not work ?
Why ?
I tried to use the Get.Cell BUT the Excel 2003 does not seem to know it exist.
I tried the above example from your book Excel Gurus Gone Wild but they do not work.
To highlight every cell that does not contain a formula , use =NOT(hasFormula) in the conditional formatting.
1. First I go ti define Name
2. Enter Names in Workbook HasFormula
3. Then go to Refers to : and entered =GET.CELL(48,INDIRECRT("RC",FALSE))
4. Then I select a range of sells
5. Select Format, Conditional Formatting, Change the first dropdown to Formula is Type = HASFORMULA and then click OK
5. Then I tried the formula =NOT(hasFormula) in the conditional formatting but it does not work ?
Why ?
