Hi all
I tried to find the answer to this to no avail.
Does anyone know if this is possible?
fgdfgd.jpg
Basically, I want to put an X in the cell in column C if the cell in column I is highlighted green and then just copy paste all the way down column C.
Sounds simple?
Any help?
How do the cells in column I get highlighted? Is it done manually, or through conditional formatting, or some other way?
Pete
Conditional formatting to highlight duplicates.
Using.... =COUNTIF(I:I,I1)>1
I'd switch the logic round and put:
=IF(COUNTIF(I:I,I1)>1,"X","")
and then make the CF dependent on whether that cell contains an X rather than doing the same calculation again.
Rory
Not sure I get you.
No cell contains any X yet, the reason I'm doing this is to I don't have to manually input thousands of X's in column C.
I just wish it was an simple as if I1(highlighted) then C1="X".
Hahah !!
In C1 enter:
=IF(COUNTIF(I:I,I1)>1,"X","")
that will give you your Xs using the same criteria that colour the cells in I. I'm then suggesting that there is no point doing the same count twice (once in column C and once in column I's conditional formatting), you can alter the formatting formula to use =$C1="X" instead.
YES !!!!!!!!!!!
:D
Thanks muchly. Great stuff !!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks