Conditional Formatting for Formulas
I have an excel spreadsheet , that contains formulas and also values , I want
to highlight all cells that contain a formula using conditional formatting. How can I do this ? |
Conditional Formatting for Formulas
"Murat Gordeslioglu" wrote:
I have an excel spreadsheet , that contains formulas and also values , I want to highlight all cells that contain a formula using conditional formatting. How can I do this ? Perhaps a viable alternative .. Press F5 Special Check "Formulas" OK will select all formula cells on the sheet at one go Then just format to taste (Format Cells) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Conditional Formatting for Formulas
try this site
http://j-walk.com/ss/excel/usertips/tip045.htm "Murat Gordeslioglu" wrote: I have an excel spreadsheet , that contains formulas and also values , I want to highlight all cells that contain a formula using conditional formatting. How can I do this ? |
Conditional Formatting for Formulas
thanks , this is what I needed
"Nikki" wrote: try this site http://j-walk.com/ss/excel/usertips/tip045.htm "Murat Gordeslioglu" wrote: I have an excel spreadsheet , that contains formulas and also values , I want to highlight all cells that contain a formula using conditional formatting. How can I do this ? |
All times are GMT +1. The time now is 06:06 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com