View Single Post
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Version?
************
Anne Troy
www.OfficeArticles.com

"neeraj" wrote in message
...
I have a workbook with several shets. There are a few cells in every sheet
which have a fill color say 'x'. I want to replace these cells with color
'y'. I attempted find replace format. In the format option in the replace
card, I could not find the 'fill color' option(there was only the font
color
option). Then I fill colored a cell with the desired color and chose it in
'choose format from cell' option. When I hit 'replace all', it colored
only
seemingly alternate cells with desired colors. How can I do it?