View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default 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