View Single Post
  #1   Report Post  
Todd
 
Posts: n/a
Default In Excel, can I shade entire rows based on the value of a single .

I'm trying to format rows in my spreadsheet based on the values existing in
two cells on that row. If the date is before today, and there is no entry in
another cell, I want the entire row to be yellow. If the date is before
today, and there IS an entry in another cell, I want the entire row to be
green. If the date is after today, the other cell doesn't matter. In this
case, the entire row would be white (or clear). Is this possible?