Forum Discussion

Jo-Anne Ryan's avatar
Jo-Anne Ryan
Copper Contributor
Jul 24, 2018

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 each on individually. I have also tried to copy and paste, but it didn't work. Is there a fomula I can use? Or am I doing something wrong.
Formulas & Functions
Need Help
  • Haytham Amairah's avatar
    Haytham Amairah
    Silver Contributor
    Jul 24, 2018

    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

Resources