Excel Query

  Brenkk 17:09 25 Nov 08
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 08

In A1

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

and drag across.

  Brenkk 08:58 26 Nov 08

Thank you yet again VoG.

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

Hands-on: Acer Predator Triton 700 review

D&AD Awards 2017: see the best design, advertising, illustration, animation and VR of the past year

How to lose weight with an Apple Watch