Forum Discussion
DannyDDG
Apr 18, 2023Copper Contributor
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 ...
- 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
DannyDDG
Apr 20, 2023Copper Contributor
Thanks again Lz. I am using =COUNTIF('EVM Work Order'!$J$13:$U$13,"<>") in my application and it works great. What would be the proper condition for any value greater than 0 in the range selected?