Conditional formatting?

[dgpenny]

A B C
Name Date Result
Emp. 1 1/10/05 FALSE
Emp. 2 1/17/05 TRUE
Emp. 3 1/24/05 FALSE

G1=TODAY()

I want emp. name in column A to highlight bold red when G1 in C answers to TRUE. Thanks.

 

[HalfAce]

If I understand what you're doing, then yes, conditional formatting will do what you want.

In A1, use Format | Conditional Formatting...
Under Condition 1 choose Formula Is
For the formula use: =C1=TRUE
Format the Font to bold & red
Hit OK and then use Format Painter to copy the same format to the range in column A that you want.

Hope it helps,
Dan