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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks