Can Conditional Formatting highlight cells containing any formula?

I'm developing a worksheet that calculates NETWORKDAYS for resource planning - copy attached.

Sometimes I know the start and end date of a contract and need to calculate NETWORKDAYS in column E.

Sometimes I know the start date and the number of contracted days but need to calculate the end date in column F.

I don't have any difficulty with the NETWORKDAYS formulas but to help me validate the data in E6:F14 I would like to highlight the cells to indicate whether it is hard coded or calculated. Is this possible?

Thanks in anticipation?

Originally Posted by tuph

I would like to highlight the cells to indicate whether it is hard coded or calculated. Is this possible?

Unable to understand your actual problem

also note quite sure what your asking

maybe this?
CTRL+` Alternates between displaying cell values and displaying formulas in the worksheet.

or this
http://www.techrepublic.com/blog/mic...formula-cells/

Obviously I didn't define my problem very well! Sorry folks.

IF any of the cells in the range E6:F14 contain a formula (any formula) I want those formula cells only to be filled with blue.
AND
IF any of the cells in the range E6:F14 contain a number I want those number cells only to be filled with pink.

I want this to function automatically and at all times.

Hope this helps!

See this:

http://tinyurl.com/CellHasFormula

using excel 4.0 formula

Thanks Tony. This is exactly what I was looking for!

In Excel 2013 there is a new function that makes this easy: =ISFORMULA(...)

You're welcome. Thanks for the feedback!


If your question has been solved please mark the thread as being solved.

In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

Hi Tony,

The function is working as expected but the name definition is not being saved with the workbook. Does the workbook need to be macro-enabled?

Yes, if you're using Excel 2007 or later then you'll have to save the file as a macro enabled file in the *.xlsm format.

OK. thanks.

You're welcome!