Conditional Formating: highlight a cell based on two cells

[rscmkj]

I am wanting to highlight a cell based on two cells. If H6>0 and F6>0 then highlight H6. Is there a way to do this?


Thank You.

 

[Joe4]

Sure. Select cell H6, go to Conditional Formatting, use the Formula option of Conditional Formatting, and use this formula:

=AND(F6>0,H6>0)

(don't forget to pick your formatting color)

 

[rscmkj]

Thank You very much, this helped me out a lot!