Excel - Find and Replace Question.

  oo7juk 13:23 07 Sep 2005


When using the above function how do you program excel to highlight the chosen cell with a colour.

I want to set excel to turn a cell a particular colour when it finds the data I'm searching for.

Also can this be set to a default option?

Thank you.

  dave_and_confused 13:27 07 Sep 2005

For the first part click on the Options at the bottom right. Then you can specify Font, Colour etc for the Replace.

Not sure about making it the default.

  oo7juk 14:56 07 Sep 2005


Thanks for that. But all I'm wanting to do is enter my data and once excel finds it, the cell is then highlighted.


  Simsy 16:38 07 Sep 2005

what you probably want is "conditional formatting", but you'd have to do this to the cells in question beforehand...

Basically the principle is that you "conditionally format" the cells with an instruction that goes along the line of;

"If the value of this cell is 9 make my background red"

Do your search and find, replacing 8 with 9, and then all the cell with the value 9 should have a red background.

That's the principle, but I suspect you need it to be a bit more specific, or possibly the range of cells might be constantly varying.

Conditional Format is via the "Format" menu.

Does this help at all?



This thread is now locked and can not be replied to.

Elsewhere on IDG sites

HP Envy x2 review: Hands-on

Iconic New York graphic designer Milton Glaser on his uplifting new subway posters

New iMac Pro release date, UK price & specs rumours

Comment suivre le parcours du père Noël ?