| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting various colums at once
Hi, I would like to add a Conditional Formatting to various colums at once.
Example if A1B1 make cells C1, D1 and F1 red, Please advise |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting various colums at once
Select C1, D1 and F1 and use a formula of
=$A1$B1 -- __________________________________ HTH Bob "Compare Values" wrote in message ... Hi, I would like to add a Conditional Formatting to various colums at once. Example if A1B1 make cells C1, D1 and F1 red, Please advise |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting various colums at once
Thank you Bob but it did not work. I selected C, d and F at once an I typed
the below formula but nothing happens "Bob Phillips" wrote: Select C1, D1 and F1 and use a formula of =$A1$B1 -- __________________________________ HTH Bob "Compare Values" wrote in message ... Hi, I would like to add a Conditional Formatting to various colums at once. Example if A1B1 make cells C1, D1 and F1 red, Please advise |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Formatting various colums at once
Are you typing the =$A1$B1 formula in the Conditional Formatting dialog box
with Condition 1 set to Formula Is? "Mary" wrote: Thank you Bob but it did not work. I selected C, d and F at once an I typed the below formula but nothing happens "Bob Phillips" wrote: Select C1, D1 and F1 and use a formula of =$A1$B1 -- __________________________________ HTH Bob "Compare Values" wrote in message ... Hi, I would like to add a Conditional Formatting to various colums at once. Example if A1B1 make cells C1, D1 and F1 red, Please advise |
| 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
