Conditional Formating: Highlighting Two Cells, in a Row

**Bob Lankin** · 10-02-2013, 11:34 PM

Hello,

I want to highlight a cell based on two bits of information supplied by the user. I've got one cell highlighted, but now want to expand it to include another cell, based on whether the next cell is higher or lower in value. If the two cells are of equal value, I do not want that second cell to be highlighted. The specific cell might to be highlighted is based on the first highlight.

So it looks like this:

0 2 1 1

Say the first zero is highlighted, based on the entered information. I now want the third number in the row (1) to be highlighted also, since it is more than zero.

Now say the first two (2) is highlighted. Here I want the the forth number in the row to also be highlighted (1), since that number is lower than the first highlighted cell. If the two related numbers are equal, I do not want that final cell highlighted, just the first one.

Here's what I've done so far.

Thank!

Bob

**Bob Lankin** · 10-03-2013, 06:46 PM

bump please bump

**FDibbins** · 10-03-2013, 06:56 PM

Hi Bob and welcome to the forum

You have had over 60 people look at your thread, but no offers to help

This tells me that your requirement is unclear to members. I suggest you try to explain in more detail, and maybe give a few sample answers and how you arrived at them

Remember, what is blatantly obvious you you, may not be that clear to us

**Bob Lankin** · 10-03-2013, 07:39 PM

OK.

I'll try again.

Say I have a row of four numbers:

0 1 1 0

I have conditionally formatted the row to highlight either the first or second column (0, or 1). I'd like to conditionally format columns 3 and 4 (1 and 0), based on whether the second number (column 3 or 4) is higher or lower than the number highlighted in the first two columns.

For example. I have highlighted the first zero. Now since the third column number is higher than zero (1), I'd like that number highlighted also.

Bob