excel for mac conditional formatting cell that does not contain formula

In the Refers to: box type the following: NOT(GET.CELL(48,INDIRECT(rc,FALSE))).

The cool thing about this is, that if any cell in the range changes from being a constant to a formula (or vice versa), the font colour will automatically change.

For a better experience, please enable JavaScript in your browser before proceeding.

It has a number. Any ideas W.

Kirk Crawford Tularosa, New Mexico.

Whats your question or issue What condition(s) do you want to define.

How to I flag those cells that have a number as opposed to a formula W.

I can not use VBA.

Beside, Im not sure where, cell or column, this is to be put in.

W. Kirk Crawford Tularosa, New Mexico.

Conditional Formatting for Constants in Excel - AMT Financial Training Select the range of cells (it can be a large area) you want to conditionally format to test for constants, and create the rule as instructed in the link.

If I try to put that formula in there, NOT(GET.CELL(48,INDIRECT(rc,FALSE))) I get and error message, Youve entered too many arguments for this function.

Format all cells based on their values Format only cells that contain Format only top or bottom ranked values Format only values that are above or below average Format only unique or duplicate values Use a formula to determine which cells to format I used the last one.

And it didnt work.

Thank you for all you have put up with me.

In cell A2 if the value A then allow both positive and negative integers.

I have attached sample data, i need someone to help me convert the left side to how the data looks on the right.

Excel For Mac Conditional Formatting Cell That Does Not Contain Formula