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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…