Gr8 Teethless mama
I Appriciate for your Patience
Thanks again
"Teethless mama" wrote:
See the attached file
http://www.4shared.com/file/11900050...ormatting.html
"Hardeep Kanwar" wrote:
thanks for reply
good to see u Teethless mama.
Your solution Colored the All cell which have no formula.
My Requirement is totally different with your solution.
Ok, Lets start again
I have simple Sheet with many Formulas But without any colors.
See the Link
http://spreadsheets.google.com/ccc?k...tfnY3k8cc0TP9A
In E2 i have a simple Sum function. If someone Change or Over Write the Cell
it will Turn into Red Color.
NOTE: THIS SHEET HAVE ONLY ONE FORUMAL , MY ORIGINAL SHEET HAVE THUNDRED
FORUMLA.
Please revert for further Clarification
regards
Hardeep kanwar
"Teethless mama" wrote:
"NotFormula" is a defined name no quotes
Refers to: =NOT(GET.CELL(48,INDIRECT("rc",FALSE)))
Conditional Formatting:
=NotFormula
Format any color you like :)
"Hardeep Kanwar" wrote:
Is it Possible to Change Using CF.
Means if Some one overWrite the Cell it Change the Font Color.
I Try in Another Site But Couldn't Find the Solution
http://www.mrexcel.com/forum/showthread.php?t=396658
Thanks in Advance
Hardeep kanwar