Previous Topic Next Topic

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
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Computer turns on but no display
Lancenz -
Lancenz -

2 responses
No display on monitor, light blinks
Harsh20_4 -
Anonymous -

9 responses