conditional formatting on sum function not on A1+A3

A

anil

I am using "CellhasFormula=GET.CELL(48,INDIRECT("rc",FALSE))" to
conditionally format/colour the cells those have formula. Most of the
formulas are like sum(C1:C3) or sum(AX21:AX34) or $C$3 (referening to
other cell in same of other worksheets).

In the cells where user has to enter data; user enter as C2=25+30
(with comments) instead of C2=55.

Now problem I am facing is that C2 is also recognised as formula and
conditional formatting is applied on it.

Can I do somehow that conditional formattiing is applied only on
formulas like =SUM(B3:B6) or count(B3:B6) not =25+30-2 ?

Regards

Anil
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formating only on sum function not on =A1+A2 0
SUMCOLOR with conditional formatting not working 3
Excel 2007 - A Conditional Formatting ?'s 1
Pivot Table/Conditional Formatting Guru Help 2
Conditional Formatting Based on Value of Adjacent Cell 3
Using a conditional function to sum the difference between two col 3
Help with conditional formatting 3
Excel 2007 Conditional formatting with number formats 3

Top