About Command Ctrl+F

[krispar]

How can i color all the rows that i found on giving the Command "Ctrl+F" ? for example i press Ctrl+F and then type Terminal there and then i press Find All , Now How can i Color all the Rows that i Found .

 

[Xiq]

Hi Krispar,

You can do that with the "Replace"-tab (CTRL+H).

 

[ThrottleWorks]

Hi Krispar, could you also try "conditional Formatting".
Will that work for you ?

Please check this link, http://www.contextures.com/xlCondFormat02.html

I wanted to prepare a sample file for you, that would have been more easier but for some reasons CF is not working on my PC.

P.S. - If VBA is an option for you, please check uploaded file.
Would request you to check the results on dummy data first.

P.S. 2 - Please check the revised file, you will need to enter the field name in an "Input Box" , also there is a correction in the code.

After doing this, I realized, conditional Formatting is the best way to go for this.

 

[ismailzkhan]

Hi Krispar,

Check attached file for different 'conditional formatting' prepared by Chandoo.

Regards,
I Khan

 

[krispar]

Thanks everyone for ur help
, it'll save my time