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
|