Conditional Formatting in Excel 2007

  tonyq 19:55 25 Aug 2009

I have set Conditional Formatting on a column of numbers by selecting all of the the cells and applying the following conditions,Red fill cell below 50, green fill cell above 50. My problem is that when I come to place more numbers in the column the new cells do not get formatted.I presumed that the formatting should continue with new entry's. What can I be doing wrong.

  VoG II 20:14 25 Aug 2009

It won't automatically copy the CFs unless your data is in a Table (see the Help).

When you add mode data, click in one of the 'old' cells, click the Format Painter on the Home tab then select the 'new' cells. The CFs should be copied.

  VoG II 20:15 25 Aug 2009

For "mode" read "more".

  tonyq 10:26 26 Aug 2009

Thank you VoG.

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

Elsewhere on IDG sites

Dell XPS 13 9370 (2018) review

No need to scan sketches into your computer with Moleskine's new smart pen

HomePod review

Streaming : Netflix ou Amazon Prime Video ?