Conditional formating only on sum function not on =A1+A2

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)
and =$C$3 (referening to other cell in same of other worksheets).

In the cells where user has to enter data; sometimes user enter the
data 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
functions like =SUM(B3:B6) or COUNT(B3:B6) not on '=25+30-2'

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 formatting on sum function not on A1+A3 0
Conditional formating not working 5
Conditional Formating - Exceeds Cutoff 2
Using a conditional function to sum the difference between two col 3
Function to Sum colored cells values not working 4
Conditional formating based on another cell value 3
SUM with variable range 6
Change cell colour on formula result change, no conditional format 0

Top