Conditional Format a row based on a cell?

W

WRCH5

Hello,
I am wondering if MS Excel can do the below: If anywhere is column A
there is a "W" then make the entire row BOLD. Any ideas?
Thank You
 
T

Teethless mama

Select entire rows, then enter the formula in the Conditonal Formatting
=$A1="W"

Format Font BOLD
 
Top