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?