Conditional format entire column

  • Thread starter Thread starter JC
  • Start date Start date
J

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
 
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.
 
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)
 
Hi,

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