Forum Discussion
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.
- How to create scenario summary in Excel?
To be sure, "Dark Red if H2 is red" it shall be as here or "if H2 is Yes" ?
