Google Docs Spreadsheet Automatic Coloring

Question

I am looking for a way to automatically change the color of the minimum cell in a row in google docs spreadsheet.

So, for a table like

1 | 2 | 3
4 | 2 | 1
2 | 1 | 6

It would color all the cells with '1' in them.

Answer 1

In the dropdown menu, Format->Change color with rules...

Then set your rules and your color. You can select multiple cells and do this also.

Edit:

That is the extent of what you can do with coloring. You can maybe find a complex formula to find the minimum of the cells, and then if that matches what is in the cell, then color it, but you may want to use Excel instead of Google docs if this is a critical thing for you.