Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formating
In Excel 2007, for a large number of cells I want to create a conditional
formating rule based upon the value in the next cell. For example, if the next cell has the value "c" then I want the original cell to have a green fill and be boldened. I can create the rule for the single cell but have not been able to copy it to the other cells which should be looking at the value in the cell next to them |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional formating
Cell references in your description would help immensely but here is an
example. Select column A and CFNew RuleUse a Formula =$B1="c" Note the $ sign to fix the column but let the row number increment. Gord Dibben MS Excel MVP On Mon, 31 Aug 2009 13:44:01 -0700, Pa Maher <Pa wrote: In Excel 2007, for a large number of cells I want to create a conditional formating rule based upon the value in the next cell. For example, if the next cell has the value "c" then I want the original cell to have a green fill and be boldened. I can create the rule for the single cell but have not been able to copy it to the other cells which should be looking at the value in the cell next to them |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formating and Mid | Excel Discussion (Misc queries) | |||
conditional formating with len | Excel Discussion (Misc queries) | |||
CONDITIONAL FORMATING | Excel Discussion (Misc queries) | |||
Conditional Formating help. | Excel Discussion (Misc queries) | |||
Install dates formating using conditional formating? | Excel Discussion (Misc queries) |