Home

Finding the data and to color code it

NishantSalunkhe
New Contributor

Hi, 

I have a excel where i need to find data from Crtl+F and I have to color code that cell in green. 

i have to manually search that data and do the process. How i can do in one go? 

 

Please reply with any of your thoughts. It might be helpful for me. 

 

3 Replies

Hi 

 

There is an option that you can add to the Quick Access Toolbar. It will not be turned on by default. 

 

In Excel:

Go to File->Options->Quick Access Toolbar->find Repeat and add it to the Customize Quick Access Toolbar section. 

 

When this option is not available to use it will be gray. You could also use this with the shortcut Ctrl + Y.

 

Hope that this helps you! 

 

Cheers 

Yeah I tried that.

It returns to same cell again.

I have a list of data to be done like that.

You can see everytime i have to paste in Find what. There are such 500 entries

2.JPG

Good idea.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies