after conditional format changes color keep new color

Hi,
I’m trying to keep a running total of numbers based on the date. On the current date, conditional format changes the numbers to red.
I’m using a function macro to add all the red numbers in a column

HTML Code: 

And in the total cell, where T1 is the reference cell for color, and numbers is the range to add:

HTML Code: 

How do I keep the numbers from changing back to the original color (black) when the date changes with out going to Copy..Paste Special each time before I close the spreadsheet?

Mike

You'd need to check if the cell HasCondition then check what it is, find the colour and then make the font that color but that would defeat the purpose of conditional formatting, maybe rather than use conditional formatting you should use vba to change the font colour on condition (whatever your condition is), perhaps in the worksheet_activate event.

Got a sample workbook?

Hi Simon Lloyd,

It'll take a couple of days, but I'll make up a sample sheet
I set up the conditional format to have the font color change to red when it's today.
I use =today() in the condition and have the font color change to red
I just don't know how to keep the color changing back when it's tomorrow!

Mike

If you have a certain column that has dates in and your looking to progressively colour them as the days advance then this should work

Please Login or Register  to view this content.

Right click the sheet tab your working with and paste this in, now everytime you activate the sheet it will check for todays date in column A for the nuber of entries there are

I'm having trouble adapting the code to what I. I'm still learning how to use code. sort-a self taught

In column A, i put in a date the bill is due, In column B is the amount. At the bottom of the amounts in column B I have a total cell that adds only the red numbers. Which was changed by conditional format,That way I know how much has gone out at any time during the month.
I'm trying to get your code to work. It looks easier to use

At the start of the new month, I start a new spreadsheet. Some of the dates in column A might changes also some of the amounts in column B might change.


Mike