Conditional format but referred from other cell

[Lamb Chop]

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

 

[Gord Dibben]

Select range of cells in column C to format.

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

Format>Font>Bold


Gord Dibben MS Excel MVP

 

[VBA Noob]

Hi,

Select Col C and put this formula in Conditional formatting

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

VBA Noo

 

[Gord Dibben]

Douglas

Format>CF>Cell Value is: greater than or equal to............=cellref(note the
= sign)

Watch the cell references. Use Absolute or Relative depending upon what you
want to compare.


Gord

 

[Gord Dibben]

Send the workbook to my email with a description of what you want colored.

Change the DOT and AT to unmung my address.


Gord

 

[Gord Dibben]

Done, but you realize all the email-bots now have your address.

Gord

Gord Dibben: I am sorry, but I do not see your address anywhere. (I
understand why you are not posting your email address here, but I do not
understand your instructions. If you do not mind contacting me by email so
that I might write back to you, my email address is
(e-mail address removed). I have a handy example ready to go).

Thank you.

DOUG ECKERT

Gord Dibben MS Excel MVP