Previous Topic Next Topic

Display yes where data is present in Excel

Closed
Jody - 16 Nov 2010 à 16:17
 RayH - 16 Nov 2010 à 17:27
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
Related:

1 response

Réponse 1 / 1
RayH
16 Nov 2010 à 17:27
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

Similar discussions

Copying data from one Excel sheet to another.
Remedial -
Kav -

30 responses
Hosted app data will not clear
Woody_3336 -
woody_3336 -

7 responses
How to extract data from one excel file to another
zamorin -
zamorin -

2 responses
How To Fix Mint Mobile Data Not Working?
sachin327 -
joshitha -

2 responses