| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Fill down option in conditional formatting?
I have two columns showing figures for each year. I am trying to set
conditional formatting up so that if the figure in column A is greater than the figure in column B then it changes colour. I can do this individually for each row, but is there a way of excel changing which cell it compares against automatically? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Fill down option in conditional formatting?
If you select entire columns A:B and enter formula =$A1$B1 as condition in
CT dialog then Excel will do what you are looking for. Regards, Stefi €˛Gemma€¯ ezt Ć*rta: I have two columns showing figures for each year. I am trying to set conditional formatting up so that if the figure in column A is greater than the figure in column B then it changes colour. I can do this individually for each row, but is there a way of excel changing which cell it compares against automatically? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting / Cell Fill Colours | New Users to Excel | |||
| fill autoshape color with ref cell conditional formatting | Excel Worksheet Functions | |||
| How to copying conditional formatting using the fill handle. | Excel Discussion (Misc queries) | |||
| Flashing cell for conditional formatting as an option | Excel Worksheet Functions | |||
| Cell Formatting Conditional On Other Cells Fill Color? | Excel Worksheet Functions | |||
Linear Mode
