Forum Discussion

DannyDDG's avatar
DannyDDG
Copper Contributor
Apr 18, 2023

formating

I would like to set the background color of a cell based on the numerical content of a range of cells in a different sheet of my workbook.  Specifically, I want a cell to change color if any cell is ...
  • Lorenzo's avatar
    Apr 18, 2023

    Hi DannyDDG 

     

    See attached file where Sheet1!A1:A3 have Conditional Formatting rules that highlight cells if Sheet2!A1:K1, Sheet2!A2:K2... range has at least 1 value

Resources