Conditional format entire column
 

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

Conditional format entire column
 

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

Conditional format entire column
 

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

Conditional format entire column
 

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