I want to highlight rows where a cell meets a criteria. I have simple table

```
| A | B | C
---------------------------
1| Row number | Name | Val
2| 1 | Mih | 3
3| 2 | izz | 4
4| 3 | don | 2
5| 4 | ron | 1
6| 5 | |
7| 6 | |
```

The rows 6 and 7 (Excel rows, or 5,6 from `Row number`

column), the `Val`

is considered as 0.

I highlighted rows (I chose `Use a formula to determine which cell to format`

with bold and green background color) by formula `$C2<3`

... it will highlight rows 6 and 7 (latest two)

I want to exclude those `Val`

is 0.

I tried like `=IF(AND($C2<2,$C2>0), TRUE, FALSE)`

but is not working means I got error from Excel.

Also I tried `=AND(C2<2,C2>0)`

, same thing.

How to achieve that ?

`=AND($C2<2,$C2>0)`

and it worked for me. Meaning that it highlighted row 5 only. – Rey Juna Nov 1 '18 at 16:10