Conditional format entire column

[JC]

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 A1>B1 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

 

[Joel]

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.

 

[T. Valko]

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 tab>Styles>Conditional Formatting>Manage rules>New rule>Use a
formula to determine which cells to format
Enter this formula in the box below:
=A1>B1
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 Format>Conditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:
=A1>B1
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<>"",A1>B1)

 

[Shane Devenshire]

Hi,

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