Select range of cells in column C to format.

FormatCFFormula is: =$B1="today"

FormatFontBold


Gord Dibben MS Excel MVP

On Sat, 29 Jul 2006 06:41:03 +1000, "Lamb Chop" wrote:

How can do this:

A:A contain date
B:B has a formula e.g for B1 =if(A1=today(), "today", "")
B2 =if(A2=today(), "today", "") etc

C:C has some data


I would like to bold the data in cell C if the corresponding B is "today"


Thanks