Create a font based on todays date

[markmdill2]

I have a spreadsheet that tracks some things. Column A holds a date, Column B holds a #; And Column C holds a $ amount. I want to change the font of Column C to red if Column A plus Column B is Greater than today.

So for example;

A	B	C
6/10	10	$100
6/1	10	$300

<tbody>
</tbody>

In the example above, the $300 is red because today is > 10 days after 6/1.

I don’t know a lot about excel VBA. I have written some macros’s, but they execute when I click a button. I would prefer this just work all the time, but I don’t know if that means this little program just loops and loops and that may not be a good idea. So I suppose an alternative is that some button could be pressed, and then it looks at all the rows.

One thing I can’t pinpoint is how many rows; in the above example it is just two rows; but I add and delete rows all the time. The part that stays the same is the columns.

 

[Roderick_E]

You just need to use "Conditional Formatting". On your Excel, click the HOME menu and look for conditional formatting. You can then input your formula there and change the cell or text color as desired when conditions met.

 

[markmdill2]

I tried that, but maybe I don't know the right formula. Is it A*+B*=Now or A1+B1=Today? or something else? How do I wrote a formula that applies to any row?

 

[markmdill2]

I figured it out; had to make the row match the top row in the range, and put () after the word "Now" and it worked.