Hey guys,
I have two colums "A" & "B" with dollar values all the way down in each (500
rows)...I want to conditional format them quick...so IE:

If A1B1 then color cell A1 red...

how do i get that to copy all the way down my column so A2 & B2 look at each
other and A3 & B3 look at each other and so on?

thanks!!
~JC

To copy conditional formating select cells with the formating. the
PasteSpecial selecting copy "Format". Make sure you include dollar sign
where necessary in formulas so they copy properly.

"JC" wrote:

Hey guys,
I have two colums "A" & "B" with dollar values all the way down in each (500
rows)...I want to conditional format them quick...so IE:

If A1B1 then color cell A1 red...

how do i get that to copy all the way down my column so A2 & B2 look at each
other and A3 & B3 look at each other and so on?

thanks!!
~JC

What version of Excel are you using?

The technique is the same but the menu locations are different depending on
the version.

For Excel 2007:

Select the *entire* range of cells. Assume this range is A1:A500
Goto Home tabStylesConditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format
Enter this formula in the box below:
=A1B1
Click the Format button
Select the desired style(s)
OK out

In Excel versions 2003 and earlier

Select the *entire* range of cells. Assume this range is A1:A500
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=A1B1
Click the Format button
Select the desired style(s)
OK out

If cells in column B might be empty while cells in column A contain numbers
you might want to use this formula:

=AND(B1<"",A1B1)

--
Biff
Microsoft Excel MVP


"JC" wrote in message
...
Hey guys,
I have two colums "A" & "B" with dollar values all the way down in each
(500
rows)...I want to conditional format them quick...so IE:

If A1B1 then color cell A1 red...

how do i get that to copy all the way down my column so A2 & B2 look at
each
other and A3 & B3 look at each other and so on?

thanks!!
~JC

Hi,

Select cells A1:B1 and double-click the fill handle. Hold down the Shift
key and press Ctrl+Down arrow.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"JC" wrote:

Hey guys,
I have two colums "A" & "B" with dollar values all the way down in each (500
rows)...I want to conditional format them quick...so IE:

If A1B1 then color cell A1 red...

how do i get that to copy all the way down my column so A2 & B2 look at each
other and A3 & B3 look at each other and so on?

thanks!!
~JC