Color Match Adjacent Cell

  • Thread starter Thread starter DOUG ECKERT
  • Start date Start date
D

DOUG ECKERT

I have a conditionally formatted cell which is green. How would I instruct
the cell below it to match the color?

Doug
 
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
 
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.
 

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

Moving cell contents to new cell loses background color in old cel 4
Excel Highlighting duplicates 0
Counting the number of rows based on the color 2
Excel Macro to automatically go to the right of the last colored cell 0
Help needed 0
How to filter rows data based on background color of individual cells 1
Excel VBA 1
Excel Change tab color in Excel with Conditional Formatting formula in a cell 0

Back
Top