ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional formating only on sum function not on =A1+A2 (https://www.excelbanter.com/excel-worksheet-functions/218119-conditional-formating-only-sum-function-not-%3Da1-a2.html)

anil

Conditional formating only on sum function not on =A1+A2
 
I am using "CellhasFormula=GET.CELL(48,INDIRECT("rc",FALS E))" 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



All times are GMT +1. The time now is 04:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com