Hi. Basic question here. Is there any way to set up conditional formatting in a cell to be based on the conditional formatting of multiple other cells?
I would like the cells in column A to turn orange, yellow, red or green based on the color of the cells on the same row in columns B-F, which are colored based on conditional formatting.
If none of the cells in B-F are green, then it would turn the cell in A red.
If one of the cells in B-F are green, then it would turn the cell in A orange.
If two of the cells in B-F are green, then it would turn the cell in A Yellow.
If three or more of the cells in B-F are green, then it would turn the cell in A green.

Is this possible? Thanks!