Excel Query

  Brenkk 17:09 25 Nov 2008
Locked

I am preparing a very long matrix and would like to have a cell at the top of each column change colour (conditional formatting) or enter a character e.g "X" if the column contains data - either text or numbers.

This way I would hope to be able to move accross the spreadsheet and see what columns have no data.

  VoG II 17:20 25 Nov 2008

In A1

=IF(COUNTA(A2:A100)>0,"X","")

and drag across.

  Brenkk 08:58 26 Nov 2008

Thank you yet again VoG.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Best Amazon Echo: What’s the best Alexa speaker?

Kano Computer Kit Complete review: A fun DIY 'laptop' that teaches kids to code

Best pro photo editors for Mac 2018

TV & streaming : comment regarder les Jeux olympiques d’hiver 2018 ?