Repetative conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
When you copy/paste a cell you'll also get the conditional formatting
copied...
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Conditioning Formatting 3
Excel Change tab color in Excel with Conditional Formatting formula in a cell 0
Conditional format if difference in cell values greater than 0.50% 1
Conditional Formatting with VBA 4
conditional format fails when copied 1
Need Macro... 8
Excel VBA 1
Conditional Formatting 4

Back
Top