Forum Discussion
A formula to highlight cells base on value of other cells
Hi I need to highlight a cell based on the value in another cell. I need to highlight cells in A when cells in H have a value higher than 0. I've tried the conditional formatting, but I have to do eac...
Hi,
Please see this GIF to figure out how to do it.
This is the Conditional Formatting formula to quickly copy it into the formula box:
=AND(ISNUMBER(H1),H1>0)
Regards
