Display yes where data is present in Excel

Closed

Jody - Nov 16, 2010 at 04:17 PM
RayH - Nov 16, 2010 at 05:27 PM

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 response

Answer 1 / 1

RayH
Nov 16, 2010 at 05:27 PM

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