Automatic colouring of a specific value wherever found in a table [closed]

Question

I am looking for a way to automatically change the color of the minimum cell in a row in Google Sheets. 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->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.