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

Lorenzo's avatar
Lorenzo
Silver Contributor
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'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
      • Lorenzo's avatar
        Lorenzo
        Silver Contributor
        Apr 19, 2023
        Glad you have a solution & figured it out + Thanks for providing feedback

Resources