Highlighting Cell if Formula is Removed

[bionio]

Hey guys, I was wondering if there is way (without using VBA) to highlight a cell if the formula within the cell has been deleted.

I am using VLOOKUPS to post data from a separate worksheet but there are cases in which I need to add data manually. So i would like to highlight the cell to remind me.

 

[T. Valko]

Hey guys, I was wondering if there is way (without using VBA) to highlight a cell if the formula within the cell has been deleted.

I am using VLOOKUPS to post data from a separate worksheet but there are cases in which I need to add data manually. So i would like to highlight the cell to remind me.

See this:

http://tinyurl.com/CellHasFormula

 

[shg]

Although using the Excel 4 macro GET.CELL isn't VBA, you will still have to save the workbook as an xlsm to use it.

 

[T. Valko]

Although using the Excel 4 macro GET.CELL isn't VBA, you will still have to save the workbook as an xlsm to use it.

Only if using Excel versions 2007 or later.

 

[shg]

Since xlsm didn't exist prior to that, that's quite right. Saved in an xls, you will still have to enable Excel 4 macros.

 

[bionio]

See this:

http://tinyurl.com/CellHasFormula

Hmm.. It works but it highlights the data with formulas and I do not understand how this solution works the way it does.

 

[T. Valko]

Hmm.. It works but it highlights the data with formulas and I do not understand how this solution works the way it does.

Ok, so you just need to reverse the logical test.

Try it like this:

=IsFormula=FALSE

 

[bionio]

Ok, so you just need to reverse the logical test.

Try it like this:

=IsFormula=FALSE

Thank you. it was actually =GET.CELL(48,A1) =FALSE

 

[T. Valko]

Thank you. it was actually =GET.CELL(48,A1) =FALSE

You're welcome!

Either way will work. It just seems more logical to me to use =IsFormula=FALSE.

 

[bionio]

Could you explain what =GET.CELL(48,A1) does?