copying conditional formatting

**Lugar07** · 11-14-2011, 07:52 AM

I have a bunch of cells where I would like to write a number representing a task. Once any of the task is assigned to a person, I would like to highlight the number from the task list. So far I've managed to create the rule in the rule manager, but I can't copy it to apply it to all the other cells. I've read about paste special, format copy, but none of these two seems to work, maybe I'm doing it wrong...
Any suggestions??

**Domski** · 11-14-2011, 07:59 AM

Hi,

You can usually apply conditional formatting to more than one cell just by selecting them all first but the copy...paste special...format should also work. Can you explain what condition you are trying to apply and/or upload a sample workbook?

Dom

**Lugar07** · 11-14-2011, 10:34 AM

I uploaded an example. Mi intention is to be able to write a number within A1:C33 and it will be crossout the number from the list. As i said, so far i have done it with help of the rule manager, and the rule is illustrated in the pic.

It's in danish, but what is says is: cell value equals to $A$1. I can't select more than one particular cell at a time.

I can't copy the format from cell A1, into the other cells. That is my issue.

What do you think?

**Domski** · 11-14-2011, 11:15 AM

Select D1:D33 and then in conditional formatting use this as the formula:

=COUNTIF($A$1:$C$33,D1)>0

and set your format.

Dom

**Lugar07** · 11-14-2011, 04:02 PM

Still no luck man,

I picked the cells D1:D33/conditional formatting/new rule/use a formula to define the cells to format/ I copy what you wrote,=TÆL.HVIS($A$1:$C$33,D1)>0 (danish version) and then an error shows up about an error in the formula. I went also through formula/insert function.
Then I choose the area, but it ask for a criteria.

Thanks for your patience...

**Lugar07** · 11-14-2011, 05:42 PM

Got it!

The formula was =TÆL.HVIS($A$1:$C$33;D1)=D1
(COUNTIF) ,)
I guess you had a typing mistake, using a colon instead of a semi colon...

Thanks a lot for your help!!