Conditional Formating

[Faisal]

I have a data containing two columns empid and emp desg .My requirement is to highlight the empid based on emp designation .for instance i need all the account managers id highlighted .

 

[Luke M]

Select the EmpID column. I'm assuming it is column A and emp desg is col B. Select Conditional Formatting, new rule, based on formula. Formula is:

=$B2="account manager"


Setup the formatting as desired.

Ok out.

 

[Faisal]

Hurray It works thanks a lot

 

[Faisal]

Hurray It works thanks a lot

 

[Faisal]

Multiple conditional formatting work fine can we apply conditional formation on more then two conditions assuming highlight all the id ( col a) the manager ( col B ) of Accounts department col ( c)

 

[Luke M]

Sure thing, just use the AND function.

=AND($B2="account manager",$C2="Accounts")

 

[Faisal]

thanks u r great