Autoformat Excell Cells

  Legslip 15:32 17 Aug 2009
Locked

Is there any way of formatting excel cells so that they fill in a selected colour when any data (text or numeric) is entered into them?

  VoG II 16:12 17 Aug 2009

Take a look at Conditional Formatting click here

  Legslip 13:18 18 Aug 2009

Thanks VOG and I may be blind but I cannot see the answer here. To clarify, I want blank cells to change to a colour when I enter any text or numerics in them.

All it is, is an action list and if a task is completed by entering the relevant number/text, the unfinished tasks are obvious by not being coloured.

There may be a way of programming this through conditional formating but I can't see it.

  VoG II 13:36 18 Aug 2009

Select the whole sheet by clicking the grey square to the left of A and above 1.

Format > Conditional Formatting, click the dropdown to change to Formula Is, enter the formula

=A1<>""

Then click the Format button, apply a format and OK your way out.

  Legslip 15:22 18 Aug 2009

Absolutely brilliant. Just what I wanted. Thanks VoG.

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

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment regarder des séries et talk-shows américains en France ?