I am having some issues with using `INDIRECT`

to apply conditional formatting.

I have column G which carries a percentage. I want to conditionally format column H based on the percentage being greater than 0 and less than 100.

I have attempted the following without success:

```
=AND(INDIRECT("G"&ROW())<100%,INDIRECT("G"&ROW())>0%)
```

This will return the correct value in a cell (true) and fail with conditional formatting

```
=IF(INDIRECT("G"&ROW())<100%,IF(INDIRECT("G"&ROW()>0%,TRUE))
```

This will return the correct value in a cell (true) and fail with conditional formatting

```
=IF($G2<100%,IF($G2>0%,TRUE))
```

I saw this in another solution. The $ is supposed to force a reevaluation on each row. This did not work either.

Additionally, I've tried both 100% and 1 in the formulas without success.

Any suggestions?