Conditional Formatting

[Guest]

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

 

[JE McGimpsey]

One way:

Select A2:Ax, with A2 active.

Choose Format/Conditional Formatting...

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

 

[Guest]

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

 

[Guest]

it worked - thank you

One way:

Select A2:Ax, with A2 active.

Choose Format/Conditional Formatting...

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