Condition Excel... And Repeat
May 7, 2012 2:38 PM Subscribe
Excel Filter: Advanced Conditional Formating, Format based on type of formula used (average, sum, sumproduct etc..)
posted by MechEng to Computers & Internet (5 answers total) 3 users marked this as a favorite
How do I conditionaly format a cell based on the formula. I would like to be able to search a cell for what type of functions are being used.
Say cell A1 = Average(A2:Z2)
and in A2 = if(iserror(find("Average",A1,1)),"NO","YES")
result of the find formula in this case is error, because it can't find the word average. I would like it to be able to search the formula and not the result.
how do I trick excel to let me search the formula for a specific keyword??? Is their a cross function to do this.
based on the formula in A2 you could easily bury that into a conditional formula assuming it cand find the term used in the function.