View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sheeloo[_3_] Sheeloo[_3_] is offline
external usenet poster
 
Posts: 1,805
Default Conditional Formatting

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
=B1A1
Choose formatting
Click Ok



"Beep Beep" wrote:

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.