Change row color if = to todays date

**RunHard** · 11-05-2008, 01:22 AM

Hello again,

I have a workbook that contains approx 75 worksheets. In column B of each worksheet are numerous pre determined dates. On each of the actual (real) dates data is entered into the same row and in various columns. For ease of data entry I want to change the row color when the predetermined date matchs the actual date. Is this possible?

Runhard

**JBeaucaire** · 11-05-2008, 01:29 AM

Sure, just use Conditional formatting on those cells.

Highlight the cells
FORMAT > CONDITIONAL FORMATTING > Cell Value Is : Equal To: =TODAY()
Then click on the Format button, Patterns and select your color.

**RunHard** · 11-05-2008, 01:32 AM

Thanks JBeaucaire,

I will try that shortly.

Runhard

**RunHard** · 11-05-2008, 01:38 AM

Sorry,

I hit the reply button too quick. Will conditional formatting affect the formulas already in the various columns.

Thanks

Runhard

**JBeaucaire** · 11-05-2008, 01:58 AM

Nope. It just checks to see if the date displayed matches TODAY.

**royUK** · 11-05-2008, 05:16 AM

Moved to General Forum. This might help

http://www.excel-it.com/excel_condit...formatting.htm

**RunHard** · 11-05-2008, 10:12 PM

Hello all,

In furtherance to my initial post. Dates are in B9:B30. I can get the conditional formatting to highlight todays date but I cannot get it to highlight the entire row relevant to today's date. I only want this row highlighted for ease of data entry across 20 or more columns. I have search the posts and tried format painter but I am having no success. Am I going about this the wrong way?

Thanks

Runhard