Color coding cells based on results from 3 other cells
I have some rows that I would like colored based on what is inputted from 3 other columns.
In row 2 I want the cells A2, B2, C2, and D2 to be colored green if F2 is Yes, red if G2 is Yes, and Dark Red if H2 is red.
I then want this to be applied to all the rows in the sheet but with the color of cells of rows A, B, C, and D reflecting what value F, G, and H have in their rows.
I have some rows that I would like colored based on what is inputted from 3 other columns.In row 2 I want the cells A2, B2, C2, and D2 to be colored green if F2 is Yes, red if G2 is Yes, and Dark Red if H2 is red.I then want this to be applied to all the rows in the sheet but with the color of cells of rows A, B, C, and D reflecting what value F, G, and H have in their rows. Read More