Conditional Formatting

B

Beep Beep

I have a summary worksheet showing yearly budget figures. What I would like
to do is create a conditional format whereby lets say the figures in the
February column are greater than the figures in the January column and so on
and so forth for the entire year. Feb greater than Jan; Mar greater than Feb
etc. etc.
 
S

Sheeloo

If you have Jan in Col A, Feb in Col C and so on then select Col B-L
Choose conditional formatting
Choose Formula is
and enter the formula
=B1>A1
Choose formatting
Click Ok
 
B

Beep Beep

Sheeloo

Thanks perfect

Sheeloo said:
If you have Jan in Col A, Feb in Col C and so on then select Col B-L
Choose conditional formatting
Choose Formula is
and enter the formula
=B1>A1
Choose formatting
Click Ok
Click to expand...
 

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

Excel 2003: Conditional Formatting with Subtotals 1
Excel Conditioning Formatting 3
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
copying & incrementing formulae across open worksheets 4
Conditional Formatting in Excel 2007 1
Use Workbook tabs in a Worksheet 1
Conditional Formatting - Excel 2003 2
Changing cell colors 1

Top