Forum Discussion

DannyDDG's avatar
DannyDDG
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 a range of cells on another sheet has a value in it. Thanks

excel
    • DannyDDG's avatar
      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

      D

      • DannyDDG's avatar
        DannyDDG
        Copper Contributor
        Apr 19, 2023
        I found what you did in the Conditional format menu selection Thanks again

Resources