View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Teethless mama Teethless mama is offline
external usenet poster
 
Posts: 3,718
Default Conditional Formatting

"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