Conditional format but referred from other cell

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

Select range of cells in column C to format.

Format>CF>Formula is: =$B1="today"

Format>Font>Bold


Gord Dibben MS Excel MVP

On Sat, 29 Jul 2006 06:41:03 +1000, "Lamb Chop" <[email protected]> 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
>
>
>

Hi,

Select Col C and put this formula in Conditional formatting

=IF($B1="today",TRUE,FALSE)

VBA Noob