seventhprophet
New Member
- Joined
- Apr 7, 2014
- Messages
- 22
I am trying to create a conditional format that modifies cells in column "O" based on a date listed in Column "C". (todays date greater than 30 days from date in C).
Its easy enough to create a conditional format that does this, but I am not sure how to do this without making a separate formula for each row, IE: O5 checking C5, then another formula having O6 check C6, is there a one formula solution? or am I creating 200 separate formulas?
Its easy enough to create a conditional format that does this, but I am not sure how to do this without making a separate formula for each row, IE: O5 checking C5, then another formula having O6 check C6, is there a one formula solution? or am I creating 200 separate formulas?