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

Fujitsu Lifebook P727 laptop review

Best of the Grad Shows 2017: University of the West of England (UWE)

Best value Mac: Which is the best £1249 Mac to buy

Les meilleures GoPro 2017