Menu
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.
252
On the Home tab, in the Style group, click the arrow next to Conditional Formatting, and then click Highlight Cells Rules. Select the command you want, such as Between, Equal To Text that Contains, or A Date Occurring. Enter the values you want to use, and then select a format.
In the formula field, enter the following formula: =$C2=”Bob” Click the 'Format' button. In the dialog box that opens, set the color in which you want the row to get highlighted. Click OK.
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.
157
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
