Autoformat Excell Cells

  Legslip 15:32 17 Aug 09
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 09

Take a look at Conditional Formatting click here

  Legslip 13:18 18 Aug 09

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 09

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 09

Absolutely brilliant. Just what I wanted. Thanks VoG.

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

Surface Pro 5 News - release date, UK price, features, specs

Animator Emanuele Kabu’s psychedelic video is a stunning tribute to Lisbon city

Best Mac antivirus 2017