VBA to Color "Formula" Cells from CTRL-F

Public Clarification Board

• 

  douglimafanny

  • 4 years ago

  The formula you choose doesn't even find the text "Cash Flow!" to apply the color. You are trying to find the name of the sheet.

  • 4 years ago
• 

  aldika31

  • 4 years ago

  Please have a look of Entry #22 .. i have solved u problem without loop macro

  • 4 years ago
• 

  blui88

  • 4 years ago

  Hi,
  Please have a look of Entry # 13 with reverted Logic.
  It will give output like I explained in my Comments while describing Use Case.
  Hope to listen more from you.
  Regards
  Santosh

  • 4 years ago
• 

  subirbbiswas0

  • 4 years ago

  Hi, Requesting you to check entry #12. Thank you.

  • 4 years ago
• 

  blui88

  • 4 years ago

  hi CH,
  
  would you like to find any formula having any sheet name or want to search for any formula having particular sheet name, in currently active sheet.
  
  Regards
  
  Santosh

  • 4 years ago
  View 4 more messages
  1. 

     blui88

     • 4 years ago

     please see last image of my entry, which is highlighting cells "As per given criteria" . If no criteria is given then it will search for all formulas with any sheet name using on the currently active sheet

     • 4 years ago
  2. 

     blui88

     • 4 years ago

     Please see this use case.
     CurrentSheet=Sheet1
     there are many fields in Sheet1, which are using formulas Which derives value from various fields
     1. some field of same sheet ie. say in cell C1 value comes from =A1+B1
     2. Some fields from other sheets like say ins cell C3 value comes from =Income_Statement!G$7
     But you do not want both of above.
     Instead of You want.
     Sheet1.C5 is a field its value will be fetched on other sheet like on Debit and or Income Sheet it will be used as=Sheet1!c$5.
     
     Is it the correct case?
     or earlier line was quite right.
     Needs urgent attention
     
     Regards
     Santosh

     • 4 years ago
• 

  Farrukh Saeed

  • 4 years ago

  do you want it on entire workbook or just on active sheet

  • 4 years ago
  1. 
     Contest Holder

     • 4 years ago

     Just the active sheet please

     • 4 years ago
  2. 

     Farrukh Saeed

     • 4 years ago

     code on my entry 5 was working. results in entry 5 were just for testing purposes. if you want to test it by yourself then inbox me i will send you the file

     • 4 years ago
• 

  blui88

  • 4 years ago

  Hi,
  Please check my entry# 10 and please share your views and further instructions to take next step.
  
  Regards
  Santosh

  • 4 years ago

Show more comments