EDIT:

Okay. Thanks to BruceWayne, I have made progress.

However, the formula I ended up with:
`=AND($C3="Y",OR($G3<=0.5,$H3<=0.5,$I3<=0.5,$J3<=0.5,$K3<=0.5,$L3<=0.5,$M3<=0.5,$N3<=0.5,$O3<=0.5,$P3<=0.5))`

turns all the conditionally formatted cells of the row green simply because there is a **Y** in the cell of column `C`

.

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 `C`

row `7`

.

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 tried `=AND($C$3="Y",$G$3:$P$75="<0.5")`

I tried `=IF(AND($C$3:$C$75="Y",$G$3:$P$75="<0.5"),"")`

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.