Repetative conditional formatting
 

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?

Repetative conditional formatting
 

When you copy/paste a cell you'll also get the conditional formatting
copied...

--
Jim Rech
Excel MVP
"Danielle" wrote in message
...
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?

Repetative conditional formatting
 

Easier is to select all the cells and apply it at one time. Enter the cell
as if you were only formatting the activecell; use relative referencing if
that part of the formula must vary by cell formatted and absolute
referencing where each formula should refer to the same fixed location.

--
Regards,
Tom Ogilvy




"Danielle" wrote in message
...
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?