Repetative conditional formatting

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Danielle (Danielle_at_discussions.microsoft.com)
Date: 02/15/05 

Date: Tue, 15 Feb 2005 15:51:02 -0800

I have created a budget and I want to use conditonal formatting for an 'if x
is greater than y, then x is red'. My dilema is in the fact that I have over
200 cells in which this would need to be applied. Is there any way to copy
that formula and apply it to each cell without individually formatting each
one?

Relevant Pages

  • RE: Conditional formating problem. Please help.
    ... "Sheeloo" wrote: ... Click on Conditonal Formatting on HOME tab ... "Ayo" wrote: ... You can then pain the format over other cells you want... ...
    (microsoft.public.excel.misc)
  • RE: Conditional formating problem. Please help.
    ... Click on Conditonal Formatting on HOME tab ... "Ayo" wrote: ... "Sheeloo" wrote: ... You can then pain the format over other cells you want... ...
    (microsoft.public.excel.misc)
  • RE: Conditional formating problem. Please help.
    ... showing up as greeen instead of yellow and <30% showing up as Green instead ... Click on Conditonal Formatting on HOME tab ... "Ayo" wrote: ... You can then pain the format over other cells you want... ...
    (microsoft.public.excel.misc)
  • Cond formatting
    ... I want to output the sheet to a new workbook with the red cells but not ... with the conditonal formatting refrences as the condition the cells need ...
    (microsoft.public.excel.misc)
  • Help with copy and paste.
    ... I have a spreadsheet which has an area for data, ... table with conditonal formatting which changes the colour of the cells ... depending on the value. ...
    (microsoft.public.excel)