Global change of cells w/particular value in Excel?

[bigred]

Is there a way to do this kind of thing? An example or 2 is probably the easiest way to explain:

"Change the background color of all cells equalling 10 from white to blue"

"Change all cells which equal ABC to 15"

...ie w/o manually selecting all of them, which is more than a slight pain if you have a lot...this could really come in handy though.

[Giggywig]

Find and Replace. You can set the format there, too.

[Leftus]

Conditional formatting for color. Your version may vary.

http://www.wikihow.com/Apply-Conditional-Formatting-in-Excel

[Wowbagger]

Those are all good suggestions, but you can also achieve even more power by building a macro to do it, in VBA.

[aggle-rithm]

I hate Excel with a fiery-red, unquenchable passion.

So much critical data is stored there, in a clumsy, unstable file format that is accessible only through a clumsy, unstable application that causes external applications trying to access it to crash.

If it were up to me, Excel would be banned from my company.

[six7s]

Ummmm... an Excel file will (very easily) convert to (and run as) a CSV file... how standards compliant do you need?

[AntiTelharsic]

"Change the background color of all cells equalling 10 from white to blue"

Please say you're not implementing cellular automata in Excel... :)

[Wowbagger]

I just thought of something: Wouldn't it be really cool if someone implemented Conway's Game of Life using Excel cells?
I could probably do that in short order, myself, when I have the time.

[Wudang]

http://www.mrexcel.com/pc10.php
has one example

[Wowbagger]

http://www.mrexcel.com/pc10.php
has one exampleAwesome.

[aggle-rithm]

I just thought of something: Wouldn't it be really cool if someone implemented Conway's Game of Life using Excel cells?
I could probably do that in short order, myself, when I have the time.

I've done it. The file has been lost, though.

ETA: I've also tried an Excel implementation of "Elf Bowl". Never got it working properly.

[aggle-rithm]

Ummmm... an Excel file will (very easily) convert to (and run as) a CSV file... how standards compliant do you need?

Only if the file has a single sheet and the data are neatly arranged in symmetrical rows and columns.

Not the case with the Excel files we have where I work.

[bigred]

Find and Replace. You can set the format there, too.
That was so obvious I didn't even see it. :o Or something like that. d'oh. Thanks all