Conditional Formatting
 

I think this is an easy one: lets say in column A i have employee names and
in column B I have numerical values as follows

Employee Income
John 0
Mike 100

If a value in the income column = 0, how do i get the employee's name to
appear red?

thanks

Conditional Formatting
 

One way:

Select A2:Ax, with A2 active.

Choose Format/Conditional Formatting...

CF1: Formula is =$B2=0
Format1: <font/<red

In article ,
RBG wrote:

I think this is an easy one: lets say in column A i have employee names and
in column B I have numerical values as follows

Employee Income
John 0
Mike 100

If a value in the income column = 0, how do i get the employee's name to
appear red?

thanks

Conditional Formatting
 

First, highlight all the names in your Employee column. Make sure the first
name "John" is the active cell. For this example, I'll assume "John" is
stored in cell A2.

Select Conditional Formatting
Enter the custom formula: =B2=0
Set your format (red background)
Click OK

HTH,
Elkar


"RBG" wrote:

I think this is an easy one: lets say in column A i have employee names and
in column B I have numerical values as follows

Employee Income
John 0
Mike 100

If a value in the income column = 0, how do i get the employee's name to
appear red?

thanks

Conditional Formatting
 

it worked - thank you

"JE McGimpsey" wrote:

One way:

Select A2:Ax, with A2 active.

Choose Format/Conditional Formatting...

CF1: Formula is =$B2=0
Format1: <font/<red

In article ,
RBG wrote:

I think this is an easy one: lets say in column A i have employee names and
in column B I have numerical values as follows

Employee Income
John 0
Mike 100

If a value in the income column = 0, how do i get the employee's name to
appear red?

thanks