conditional formatting for 2 colums

  • Thread starter Thread starter DArko
  • Start date Start date
D

DArko

Can somebody help me with advise:
how to apply conditional formatting on two colums with data (to compare one
to another)?
Regards
 
I would suggest more details about the data you are comparing will get
you a better chance at help.

Cell for cell down the columns? A1 = B1?

A1<>B1?

A1 found anywhere in column B?

Numbers? Text?


Gord
 
DArko said:
Can somebody help me with advise:
how to apply conditional formatting on two colums with data (to compare
one to another)?
Regards
Click to expand...

If you just want to compare cells in column A with those alongside in column
B...

Go to B1 and select Format, Conditional Formatting. Using the drop-down box
select 'Formula is' and enter "=A1=B1" (without the quotes) in the box to
the right. Click on the Format... button and select a format which will
indicate when the cells are identical (for this, I usually choose a green
pattern). Click OK twice. If A1 and B1 are the same, B1 should reflect the
format you have just chosen.

To copy the format down column B, select B1 and click on the format painter
and then click on the letter B at the top of column B (or, if you prefer,
just select the appropriate cells in column B).

Hope this helps and achieves what you want,

V
 
Yes, that is problem (MS excel 10). I wont to compare numbers in two colums
(A1<>B1?) and use icons (green if>, red if<,.)

"Gord Dibben" je napisao u poruci interesnoj
grupi:o[email protected]...

I would suggest more details about the data you are comparing will get
you a better chance at help.

Cell for cell down the columns? A1 = B1?

A1<>B1?

A1 found anywhere in column B?

Numbers? Text?


Gord
 
A1<>B1 means A1 not equal to B1

A1< B1 means A1 is less than B1

A1>B1 means A1 is greater than B1

I guess you want a couple of formulas for less or greater than.

CF formula of =$A1>$B1 format to green

CF formula of =$A1<$B1 format to red

Use format painter to copy formatting down.

What do you want if they are equal?


Gord
 
Back
Top