Formula is....

W

Worzel Gummidge

I currently have the following conditional formatting in a cell range:

COUNTIF(D4,D:D)=2

Now, I want to edit this formula so that it actually works out, if the same
values appear two times or more in the column. At the moment, the cell will
only change colour if same value appears twice. What I want it to do though
is change if same value appears twice or more

Thanks
 
W

Worzel Gummidge

Further to the above, it doesn't seem to be working. Here is what I am
using:

Formula is=COUNTIF(D4,D:D)=2

Now, if I type in an address in D32, I want that one to be formatted too.
So, do I have to conditional format each cell? What I drag cells down to
copy formula but change cell numbers, it doesn't work.
 
B

Bob Phillips

The new formula is

=COUNTIF(D:D,D4)>1

just select all the cells to be formatted, starting at D4, and enter that
formula in CF

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
W

Worzel Gummidge

Problem solved - thanks

Worzel Gummidge said:
Further to the above, it doesn't seem to be working. Here is what I am
using:

Formula is=COUNTIF(D4,D:D)=2

Now, if I type in an address in D32, I want that one to be formatted too.
So, do I have to conditional format each cell? What I drag cells down to
copy formula but change cell numbers, it doesn't work.
Click to expand...
 
Top