BillyJoe said:
I am trying to use conditional formatting to change an
entire row if the date in a cell is more than 180 days
old. How do I accomplish this?
Select the entire row.
Format > Conditional formatting
Change the first box to "Formula Is".
In the second box put this formula, changing the reference from $A$1 to
whichever cell has the date in it:
=(TODAY()-$A$1)>180
Press Format and choose your formatting, etc.
If you want to apply the same conditional formatting to several rows, it
matters exactly how you specify the reference.
If you have one date cell on the sheet and want the formatting of all the
rows to depend on this, you use an absolute reference (such as $A$1).
If you have a date in each row and you want the formatting of each row to
depend on its own date, you use a mixed reference (such as $A1).
(When formatting entire rows, the column part of the reference will always
be absolute, otherwise each cell in the row will reference a different
column.)
