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

OnePlus 5 review

Alice Saey's mesmerising animation for Dutch singer Mark Lotterman

iPad Pro 10.5in (2017) review

Comment booster votre iPhone ?