Conditional formating: "is it a formula or not ?"

[Mer1in77]

Hi all,

I was wondering if it is possible to somehow use Conditional Formatting to make the text color of whatever is in that cell, say, blue, based on if the value I'm looking at is the result of a formula or if it was entered by hand by a user.

Thanks in advance for all your help guys...

 

[Andrew Poulsom]

Ok I suspect something isn't going quite right.
When entering GET.CELL(48,!A1) in the refers to box and pressing ok all seems fine.
Then after doing the rest no color change can be seen.
After checking I found that excel has changed it to GET.CELL(48,!A65496)

Now since I like to know what I'm doing, I google'ed that function and found that the 48 is an ID that tells excel what to do in that cell and the rest is some kind of range.

My question is (ofcourse) what's that range got to do with anything ?
Why has excel changed what I input, and what does that exclamation mark do ?



PS: I hate the fact that excel translates formula names ever tried working in three languages in excel ? it's NUTS !

That would happen if A42 was the active cell when you created the name. The name uses a relative reference, so make sure A1 is the active cell when you create it.