Okay. Thanks to BruceWayne, I have made progress.
However, the formula I ended up with:
turns all the conditionally formatted cells of the row green simply because there is a Y in the cell of column
The formula should ideally check if a cell in column
C has a Y in it, and a cell on the same row within columns
H:P has a value <=0.5. If both values are TRUE, then only the cell with a value <=0.5 should be formatted GREEN.
In my included picture, cell
H7 is colored GREEN even though it is 0.99 (>0.5). This appears to be because the formula is only checking if a Y is in column
I don't understand Excel conditional formatting jargon so please explain it in layman's terms.
If a cell (eg:
C1) in column
C contains the value: Y, and ANY cell of the same row in columns
H:K is =<0.5 (e.g.
K1), then make those cells (e.g.
K1) turn GREEN. The (G) in the diagram denotes a cell that should be green.
(Diagram for clarity)
| Column C | Column H | (Column MID) | Column K | | | | | | | Y | 0.6 | 0.9 | 0.3(G) | | | | | | | (empty) | 0.5 | 0.4 | 0.3 | | | | | | | Y | 0.5(G) | 0.2(G) | 0.9 |
I plugged both formulas into the conditional format manager and set the output format to GREEN, but I'm missing something because no cells turned green.