Forum Discussion

Copper Contributor

Apr 18, 2023

Solved

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 ...

excel

Lorenzo
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
SAMPLE_CF_DannyDDG.xlsx10 KB

DannyDDG

Copper Contributor

Apr 19, 2023

Lorenzo

Thank you so much. I'm having trouble seeing the actual formula used to change the color. Is it something like +IF(range) contains value, then background color + red?

Thanks again

DannyDDG

Copper Contributor

Apr 19, 2023

I found what you did in the Conditional format menu selection Thanks again

Lorenzo
Silver Contributor
Apr 19, 2023
Glad you have a solution & figured it out + Thanks for providing feedback
- DannyDDG
  Copper Contributor
  Apr 20, 2023
  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?
  - Lorenzo
    Silver Contributor
    Apr 20, 2023
    Hi DannyDDG
    What would be the proper condition for any value greater than 0 in the range selected?
    =COUNTIF('EVM Work Order'!$J$13:$U$13,">0")
    or
    =COUNTIF('EVM Work Order'!$J$13:$U$13,">" & 0)
    (I have pref. for the 2nd)