DEAR FRIENDS,
kindly let me know that
how can we change the color or apperance of the Formula cells by using any formula on the excel sheet.
so that we come to know about the cells having formula at a click.
and how can formula cells be locked by using formula.
thanks
vaibhav
Check out the Excel Sheet i have attached. I have given you a template where i have explained how to protect cells
i am working in plastic company . this company manufacturing of Plastic Bottle for our client such as HUL , P&G . my quation :- if above company give to us mold for Bottle manufacturing. but first time we have run only trail & testing . please confirm this type of service we have show which type of service.
Deepak Sharma
Dear Vaibhav,
Use conditional formatting under home tab in excel2007 and above versions.
I hope it will definitely solve your problem.
Dear Sandeep Sharma,
I think your query is related to service tax.
Can kindly describe in a bit details, so that there will be a clarity about your question.
CAclubindia
