Search and replace color of a cell

[jskushawah]

I have some cells with blue background, I want to replace blue color to green.

How it possible?

 

[sdsurzh]

Hi,


If you are using Excel 2007 it can be possible by the following steps:

1.select the current region (all data)

2.apply filter

3.then filter by color select blue color and use Alt+Visible cells)

4.now you can change the color


Thanks,

Suresh Kumar s

 

[Debraj]

Hi Jitendra,


* Ctrl + A, Select all Cells

* Ctrl + H, go to Find & Replace

* Alt + T, Go To More Option

* In Find What Section >> Select "Choose Format From Cell" from Format Buttons Drop Down >> It will give you a FormatPicker >> Pick the Source Formatting by clicking on the Blue Cell. (or you can set your Source Formatting)

* In Replace With Section >> Select "Format" >> It will gives you Cell Formatting Form.. Set your Desired Format..(or you can choose Format from cell) In your case >> Fill >> Select Green..

* Click OK

* Now in Find&Replace Dialog Box >> Click Replace All..


It's just looks like a long task.. but actually not..


Regards,

Deb