Determine if any cell in the column has a value and Update Color of header to RED RRS feed

  • Question

  • We need to be able to look down a column and if there is a cell value in any of the cells in the column we need to turn the header RED. Is there an easy piece of code to do this?  Thanks.
    Wednesday, November 30, 2016 3:32 PM


  • Wouldn't a conditional format do the trick?

    e.g. add a conditional format to the heading cell with the formula set to =COUNTA(C:C)>1

    (Assuming the whole column has but one header cell that should have something in it)

    • Marked as answer by BlueCascade Wednesday, November 30, 2016 6:13 PM
    Wednesday, November 30, 2016 3:46 PM