Google Spreadsheet Post #2592
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Mar-31-2019
question by: Tico
https://support.google.com/docs/thread/3351311?hl=en
Conditinally format entire row, based off of an "expiration date"
Is there a way to use conditional formatting to recolor an entire row if a cell filled in with a date in the corresponding row is more than a year old
Conditinally format entire row, based off of an "expiration date"
Is there a way to use conditional formatting to recolor an entire row if a cell filled in with a date in the corresponding row is more than a year old
For example,
Cell A1 is marked with a date. The rest of the row (A2:A10) are filled in with several other pieces of information assosiated with that date. I need to set it so that if the date in A1 is more than 13 months old ("expires") that the entire row will shade in.
I know I can do this setting up a cell to be a "variable" but I would like to do this WITHOUT making another cell. This document will be going live on several business servers and I would like to keep it clean (and the less things people can mess up the better haha)
I am not sure if I am making any sense here... So I also made a test document to try and re explain what I am trying to get done here.
https://docs.google.com/spreadsheets/d/17yV6Nn-7f5CgzrFkU3LWqBv9lvfk8oz4R9v8MH9ugwA/edit?usp=sharing
thank you all for your help!!!
No comments:
Post a Comment