| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Color Match Adjacent Cell
I have a conditionally formatted cell which is green. How would I instruct
the cell below it to match the color? Doug |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Color Match Adjacent Cell
apply the same condition
-- Gary''s Student - gsnu200769 "DOUG ECKERT" wrote: I have a conditionally formatted cell which is green. How would I instruct the cell below it to match the color? Doug |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Color Match Adjacent Cell
Gary's Student: But, the adjacent cell is blank. I want the cell below the
formatted cell to show the same color, even though there is nothing in it. DOUG "Gary''s Student" wrote: apply the same condition -- Gary''s Student - gsnu200769 "DOUG ECKERT" wrote: I have a conditionally formatted cell which is green. How would I instruct the cell below it to match the color? Doug |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Color Match Adjacent Cell
Use Formula Is, rather than Cell Value Is, in your Conditional Formatting.
Specify an appropriate formula using the value in the previous cell, if that's what you want to use to determine the colour of both cells. If you use absolute addressing the same formula will do for both cells. -- David Biddulph "DOUG ECKERT" wrote in message ... Gary's Student: But, the adjacent cell is blank. I want the cell below the formatted cell to show the same color, even though there is nothing in it. DOUG "Gary''s Student" wrote: apply the same condition -- Gary''s Student - gsnu200769 "DOUG ECKERT" wrote: I have a conditionally formatted cell which is green. How would I instruct the cell below it to match the color? Doug |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| word match in string text in cell, color format cell | Excel Discussion (Misc queries) | |||
| Make text color match cell color with macro? | Excel Discussion (Misc queries) | |||
| When data match, copy adjacent value to adjacent column | Excel Worksheet Functions | |||
| Fill cells if adjacent cell match criteria | Excel Discussion (Misc queries) | |||
| how do I insert a cell based on its match with an adjacent cell? | Excel Worksheet Functions | |||
![DOUG ECKERT[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
