| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting
Sheeloo
Thanks perfect "Sheeloo" wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
| Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
| Conditional Formatting that will display conditional data | Excel Worksheet Functions | |||
Linear Mode
