EXCEL FORMULA CELLS

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

Replies (4)

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.

Leave a Reply

Your are not logged in . Please login to post replies

Click here to Login / Register  

Company
Featured 27 October 2026
semi-qualified CA

Saini Pati Shah & Co LLP, Chartered Accountants

Mumbai

CA Final

View Details
Company
ARTICLESHIP 25 October 2026
Article Intern (CA Articleship)

Arpan Bohra & Co

Hyderabad

CA Inter

View Details
Company
ARTICLESHIP 23 October 2026
CA Articleship / Article Assistant

M N Rao & Associates LLP

Vijayawada

CA Inter

View Details
Company
24 October 2026
CA Industrial Trainee

Fytomax Nutrition Private Limited

Aurangabad

CA Inter

View Details
Company
ARTICLESHIP 22 October 2026
Articleship intern

Srinath Manikanta

Hyderabad

CA Inter

View Details
Company
15 October 2026
Senior Accountant

Continental Belting Pvt Ltd

Mumbai

B.Com

View Details
Company
16 October 2026
CA article trainee

Zerdi & Co. Chartered Accountants

Pune

CA Inter

View Details
Company
30 October 2026
Asst Manager Accounts

Goodwin Pumps India Pvt Ltd

Chengalpattu

CA Inter

View Details