Conditional Formatting in Excel 2007

  tonyq 19:55 25 Aug 09

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 09

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 09

For "mode" read "more".

  tonyq 10:26 26 Aug 09

Thank you VoG.

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

Intel Coffee Lake 8th-gen Core processors release date rumours

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

Framestore’s haunting post-WWII title sequence for new BBC series SS-GB

How to install MacOS Sierra on an older Mac: Get Sierra running on Macs & MacBooks from before 2009