![]() |
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