Excel 2007 : Conditional formula

**aizen92** · 03-11-2010, 12:21 AM

i need to do a condition that:

if cell a=b=c=d then i want it to merge the 4 cells in 1 cell with the value of a
and if not, to keep them as they are, how can i do it?
help plz

**Paul** · 03-11-2010, 02:16 PM

Hi Aizen, welcome to the forum.

The following code checks to see if A1 = B1 = C1 = D1 and if so, merges and centers the cells. Whenever you merge cells, the default is to only keep the top & left-most cell data, so that's not an issue.

Please Login or Register  to view this content.

**aizen92** · 03-12-2010, 03:29 AM

Hello Paul,
thnx for the help, but unfortunately i didn't quite get how to do it, if you could please provide me with the writing way i would be grateful.
like =if(....)
Thnx in advance

**teylyn** · 03-12-2010, 03:33 AM

aizen, if you are asking whether this can be done with a worksheet formula, the answer is no.

Paul, in the interest of avoiding merged cells and all the trouble they bring with them, I'd be interested to learn how the code would look with "center across selection" instead of merging.

Care to indulge me?

**aizen92** · 03-12-2010, 03:39 AM

Actually i have 4 cells containing letters, i want to make a condition that if these 4 cells have the same letters, then i want them to show me only 1 cell with the letters found, and if not the same letters then to leave them as they are

**teylyn** · 03-12-2010, 03:55 AM

You could do some tricking with conditional formatting

If your values are in columns A, B, C, and D, select the cells from B1 to D100 (or whatever the last row of your range is, and create a conditional format - New Rule - Use a formula to determine... and enter this formula

=AND($A1=$B1,$A1=$C1,$A1=$D1)

Select a format where the text has the same color as the background (for example white text on white background), then the cell contents of these cells will become invisible.

Is that a possibility?

**Paul** · 03-12-2010, 03:56 AM

The code I provided earlier would work for letters or numbers. Below is a bit more proper code, and rather than merging A1:D1, it clears B1:D1 and then uses 'Center across selection' as merged cells can create problems down the road and are usually avoided if at all possible.

Please Login or Register  to view this content.

Place that in the worksheet module for Sheet1, put some values in A1 - D1 and test it out. If all four values match, the macro will run and should work as requested.

**aizen92** · 03-12-2010, 04:30 AM

I'm sorry guys i didnt get it too, Paul about ur code where do i write it? in a cell or what
any way here is a pic of what im planning to do, hope it helps
\1

im not that gd in programming stuff so i might need alot of help

Edit: Ok i found out how to enter Paul's code, and I appreciate it, but if it is possible to be without macro it would be great
anyway im working on the macro version hoping to see satisfying results