Conditional formatting based on condition of one cell and value of another

[jstevens_RBI]

I have a column of dates in a table that has a conditional formula applied that turns the cell color red if the date is >= today()-30. I have another column with names of weekdays in the same table. I have another column that I want to turn green if the date cell is red and the weekday is Monday. How can I accomplish this???

 

[Joe4]

Welcome to the Board!

You cannot base Conditional Formatting off of the formatting applied by other Conditional Formatting, but you can apply the same logic.

Let's say that your date is in cell A1. Assuming that your "Day of Week" is the day of week for the date in cell A1, you can just use this Conditional Formatting formula:

=AND(A1>=(TODAY()=30),WEEKDAY(A1)=2)

then apply your green color formatting.