Conditional formatting using dates

Question

I have data like this:

In one sheet I have a table A with dates (ascending order) and account balances. In another table B, I want to retrieve the balance on the last day of the month.

Now, I want to set the font color to white if the the latest date in table A is smaller than the corresponding date in table B.

See screenshot below, I want the marked area to be white (June 2014 and later). I think this can be done with conditional formatting.

Someone knows?

enter image description here

teylyn · Accepted Answer · 2014-05-09 09:15:38Z

2

Starting in A19, select the cells in the row. Create a new conditional format based on a formula

=DATE(YEAR(A16),MONTH(A16),1)>MAX($C$1:$C$13)

Format the text white for this rule.

enter image description here

answered May 9, 2014 at 9:15

teylyn

36.2k6 gold badges58 silver badges76 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Conditional formatting using dates

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related