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