Cell References

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

Guest

when I enter "X" in say D12 the cell text then turns green and then turns the
text in cells H12 to L12 green as well as lines through the text? How do I
duplicate this and how do I clear this? It is on a co-workers spreadsheet who
is no longer with my company.
 
They have conditional formatting set up. To clear go to the cells that are
changing color, format->conditional formatting, and delete all conditions.

To duplicate you can just copy the cell this conditional formatting is set
up in and paste special->formats into the cell you would like.
 
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

Please help with SUM formula dependent on results of other cells 2
Conditonal formatting 3
Counting Cells by Format 2
Entering an If formula using conditional formatting 1
MAX/MIN in range potantially including text 1
VBA Conditional Formatting .IconSets plus one other icon/symbol 14
IF formulas--please help!! 11
Using icon sets with relative references 0

Back
Top