Conditional Format a dynamic list in Excel 2007

M

mikearelli

I have data being pulled from an Access 2007 database.
I would lke to highlight the cell in the A column if the value of C column
is greater than Column B.
example would be to highlight A1 because C1>B1
C2=B2 so A2 is not highlighted
C3>B3 so A3 is highlighted
C4<B4 so A4 is not highlighted.

Do I need to set up conditional format for each line of this spreadsheet or
can conditional formatting be set up by column?

This Access data being pulled into Excel can contain 50 records or 5000
records... What is the best way to approach this
 
D

David Biddulph

Select column A.
Format/ Conditional Formatting/ Formula Is/ =C1>B1
Choose your highlighting format
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting - 2 columns 2
Sumproduct in matrix means 3
Conditional formatting of dates in two cells using Excel 2007 2
Conditional Format a range - help needed. 5
Conditional Formatting 0
Timesheet formula problem 3
Conditional format a column based on value in a different column 3
series of formulas to get to one formula 0

Top