| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Apply Conditional Formatting to other rows
Hi all,
I'm using Excel 2007. I would like to seek help regarding conditional formatting. What I would like to do is to create conditional formatting to show an increase/decrease/equal arrow if the cell is greater/less than/equal to the cell beside it. For example, if cell A2 is greater than A1, an up arrow will appear in A2. And if cell A3 is less than A2, a down arrow will show in A3. Excel does not allow me to use relative cell referencing for conditional formatting. So currently i have to do conditional formatting manually for every cell. I have a few hundred rows and columns. Is there a way I would be able to create a conditional formatting so that can be applied to all the cells? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro to apply conditional formatting | Excel Worksheet Functions | |||
| How do I apply conditional formatting to even or odd numbers? | Excel Discussion (Misc queries) | |||
| I need conditional formatting to apply to maximum % | Excel Worksheet Functions | |||
| How do I apply conditional formatting? | Excel Worksheet Functions | |||
| How do I apply conditional formatting to a text box | Excel Worksheet Functions | |||
Threaded Mode
