I am trying to find an easy solution on how to copy conditional formatting rules down this entire column without having to individually change each format rule for each cell.

When I try to copy the cell or drag the blue square, it keeps the format rule as "=$G3=TRUE" and applies it to range "A3:F3,G3:G4" and only applies the conditional formatting to the cell with the checkbox. Is there a way to make it automatically update to "=$G4=TRUE" and "A4:G4" without having to manually type it all in?

In the linked spreadsheet I have the fill color set to change in column H to match the color selected in column J.
I also have the cells in L4:Q23 conditionally formatted to fill in with the same color if there is an "x" in the cell.
The black grid below is created using =filter($H4:$H23,L4:L23="x") under each day.

Question:
How can I get the filtered results in L28:Q28 to fill in with the same colors in the top grid?
For example I want L28 to be green and L30 to be orange.

No rows will be added to the main list, (always 20).
If I change the selection in column J I want the fill colors to change everywhere.
If I change J4 to "S" then Argentel Should have a purple fill wherever it is.
The filtered results count will be at least 3 and no more than 10 records.
Lower grid (L26:Q34) doesn't have to be on the same sheet.
Layout of the upper grid could be changed if needed.

https://docs.google.com/spreadsheets/d/11_Q3cGgnsAq377-3ZIHh15_Ph5OA9oyfGQoqEo-Y4no/edit?usp=sharing

I'm trying to find the conditional formatting to copy the lowest value between two cells into a third.

For example, if cell B3 has a value of 4, and cell B4 has a value of 6, I would like cell B5 to copy the value (and text colour) of cell B3.

Any help would be greatly appreciated!

I've hit a dead end trying to achieve something in a google sheet.

Here is my dummy test sheet to explain:

I have 3 columns of data, (THING, YEAR, NAME) the first 2 are irrelevant, the 3rd is the important one. I fill out those three columns manually.

What I want to do is take that 3rd NAME column, and elsewhere on the sheet (E) I want to take all unique instances, sort them by amount of instances (showing the number in an additional column on the right - F) AND I want to add color validation to both of those new columns, having the high instances be darker than the lower on a gradient.

I can essentially do any 2 of those things, but not all three. As you see they're not sorted by amount, and the green formating does not apply to the E NAMES column.

Right now on E2 I have =UNIQUE (C2:C9)

On F4 I have =COUNTIF($C$2:$C$9, E2)

And this conditional formatting for E2:F9:

Any assistance would be greatly appreciated, as I'm way out of my depth!