Conditional format but referred from other cell

L

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
 
G

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
 
V

VBA Noob

Hi,

Select Col C and put this formula in Conditional formatting

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

VBA Noo
 
G

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
 
G

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
 
G

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
[email protected]. I have a handy example ready to go).

Thank you.

DOUG ECKERT
Click to expand...

Gord Dibben MS Excel MVP
 
Top