Format cell plus adjoining cell

  • Thread starter Thread starter davethewelder
  • Start date Start date
D

davethewelder

Hi, i am trying to figure out how to format a cells based on the value of
another cell, F66.
I have a spreadsheet with 7 lists of clients with at various locations on
the spreadsheet and a matching credit score next to them. I wish to format
the cell in the list equivelant to the value of F66 and the adjacent cell
with an outline heavy border round the two cells. I can conditional format
for one cell but not the two.

Any ideas would be greatly appreciated.

Davie
 
Use pastespecial and use formats.

Selection.PasteSpecial Paste:=xlPasteFormats
 
Joel, if the condition is true for A5 I want the border to cover A5:B5. The
additional cell will always be to the right of the conditional cell. There
are no cells with the border already created to copy.
Also I have two conditional formats already on the spreadsheet. It is the
code to reference the two cells I am trying to find.

Davie
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Format cell and adjacent cell 3
Border formatting row of cells 22
Excel Macro to automatically go to the right of the last colored cell 0
Change Format of Active Cell 15
Conditional Formatting 4
Conditional format if difference in cell values greater than 0.50% 1
recognizing conditional formatting with VBA 3
Format linked workbook cells (updated) 2

Back
Top