ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   conditional formatting on sum function not on A1+A3 (https://www.excelbanter.com/excel-discussion-misc-queries/216562-conditional-formatting-sum-function-not-a1-a3.html)

anil

conditional formatting on sum function not on A1+A3
 
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) 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


All times are GMT +1. The time now is 07:20 PM.

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