Hello, everyone!
Thanks in advance for devoting your time to my problem.
I am stuck at a conditional formatting of a range of cells (do not have a problem when formatting one single cell but would like to avoid copy/pasting the formatting each time).
- I want to achieve the following:
Higlight each cell in a range if containing a specific text (let's say "YES") and if the date associated with the column which that cells belongs to has passed. Not sure if this was clear enough, so I will try to explain it in another way.
If a cell containing specific text (i.e. "YES") is in the column "C" and this column (actually cell "C1") is associated with a date that has passed, I want that cell highlighted with a specific color. Now, where I am stuck at is applying the conditional formatting to the whole range. It is probably a trivial question for many but I am still in the process of learning.
For single cells I am using the formula : =AND(C1<TODAY(), C2="YES"). So, what I want to do is, for example, to apply this conditional formatting to the range C2:E10. How do I arrange the custom formula so that it responds to the change of dates in columns C1:E1 and so that it responds to the above mentioned specific text in each particular cell in the range?
I hope I was not too confusing.
Best regards,
MJ
Thanks in advance for devoting your time to my problem.
I am stuck at a conditional formatting of a range of cells (do not have a problem when formatting one single cell but would like to avoid copy/pasting the formatting each time).
- I want to achieve the following:
Higlight each cell in a range if containing a specific text (let's say "YES") and if the date associated with the column which that cells belongs to has passed. Not sure if this was clear enough, so I will try to explain it in another way.
If a cell containing specific text (i.e. "YES") is in the column "C" and this column (actually cell "C1") is associated with a date that has passed, I want that cell highlighted with a specific color. Now, where I am stuck at is applying the conditional formatting to the whole range. It is probably a trivial question for many but I am still in the process of learning.
For single cells I am using the formula : =AND(C1<TODAY(), C2="YES"). So, what I want to do is, for example, to apply this conditional formatting to the range C2:E10. How do I arrange the custom formula so that it responds to the change of dates in columns C1:E1 and so that it responds to the above mentioned specific text in each particular cell in the range?
I hope I was not too confusing.
Best regards,
MJ