If = Change Color
 

Hi there...

What I´m trying to do its pretty simple, but not to me.

I´m trying to make something like this...
A1 = 12/12/2006
A2 = 12/12/2006

If A1=A2, change the color of the cell to... whatever color I want it.

Is there anyway of doing it? I read everything I could on the internet, but
didn´t find anything that could help me,

Thank´s

If = Change Color
 

mike wrote:
Hi there...

What I´m trying to do its pretty simple, but not to me.

I´m trying to make something like this...
A1 = 12/12/2006
A2 = 12/12/2006

If A1=A2, change the color of the cell to... whatever color I want it.

Is there anyway of doing it? I read everything I could on the internet, but
didn´t find anything that could help me,

Thank´s

Under Format take a look at conditional formatting. It's pretty straight
forward but if you have more questions please post back.

gls858

If = Change Color
 

Select your range
Conditional Formatting
Change Cell Value Is to Formula Is
=COUNTIF($A$1:$A$2,$A1)1
Format any color you like

"mike" wrote:

Hi there...

What I´m trying to do its pretty simple, but not to me.

I´m trying to make something like this...
A1 = 12/12/2006
A2 = 12/12/2006

If A1=A2, change the color of the cell to... whatever color I want it.

Is there anyway of doing it? I read everything I could on the internet, but
didn´t find anything that could help me,

Thank´s

If = Change Color
 

Try also this sample from my archives which might be a close fit he
http://savefile.com/files/259026
CF color rows for identical successive col A value
(nicely rendered, with CF dialog screen-pic)

Presuming row1 is left empty (data from row2 down), this seems to work ok
Select cols A to C, then apply the cond format formula for condition 1 as:
=AND($A1<"",OR(OFFSET($A1,1,)=$A1,OFFSET($A1,-1,)=$A1))
Format the fill to taste, OK out
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"mike" wrote:
Hi there...

What I´m trying to do its pretty simple, but not to me.

I´m trying to make something like this...
A1 = 12/12/2006
A2 = 12/12/2006

If A1=A2, change the color of the cell to... whatever color I want it.

Is there anyway of doing it? I read everything I could on the internet, but
didn´t find anything that could help me,

Thank´s