Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formating or IF Function | Excel Discussion (Misc queries) | |||
Do I use conditional formating? | Excel Worksheet Functions | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) | |||
Conditional Formating | Excel Worksheet Functions | |||
Conditional Formating & Rand() function | Excel Discussion (Misc queries) |