google sheets - Automatic colouring of a specific value wherever found in a table

Question

(Closed.) This question is off-topic. It is not currently accepting answers. question from:https://stackoverflow.com/questions/958364/automatic-colouring-of-a-specific-value-wherever-found-in-a-table

Answer 1

In the dropdown menu, Format->Conditional formatting...

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.