Display yes where data is present in Excel

[Closed]
Report
-
 RayH -
Hello,



In excel, how can I get column W to show "Yes" in red, if there is data is column L.

Please share... :) Thanks in advance

1 reply

In column W, change the font color to Red then type in this
=IF(L2<>"","Yes","")


Copy the formula down all the required cells in column W