Conditional Formatting issues

**ragingfred** · 03-20-2013, 12:17 PM

I have two different columns that check a third and if they match the backgrounds change to the columns respective color and if they don't the cells change to show an error.

Column 1 Conditional Formatting <-- Works
Condition 1: Cell Value Is not equal to =$B1 = red background
Condition 2: Cell Value Is equal to =$A1=$B1 = tan background

Column 2 Conditional Formatting <-- Works
Condition 1: Cell Value Is not equal to =$A1 = tan background
Condition 2: Cell Value Is equal to =$B1=$A1=$C1 = blue background
Condition 3: Cell Value Is not equal to =$C1 = yellow background

Column 3 Conditional Formatting <-- Broke
Condition 1: Cell Value Is not equal to =$B1 = red background
Condition 2: Cell Value Is equal to =$C1=$B1 = yellow background

Errors Column 3
Matching cell backgrounds turn white if 0 value
If Numbers greater than 0 match or don't background turns red

**Richard Buttrey** · 03-20-2013, 12:23 PM

Hi,

You'll need to upload your workbook.

You'll also need to say what you want to see in column 3 if the cell in questions is zero.
Also what do you mean by ' Numbers greater than 0 match or don't'?
Some specific actual examples would be useful.

**ragingfred** · 03-20-2013, 01:57 PM

I've uploaded the worksheet. I've found that it works when you type data into the individual cells on the 3 report pages, and when data is pasted in as value only on the first 2 report pages, but when data is pasted into the m6 page the cells on the cuts page do not update properly.

**Richard Buttrey** · 03-20-2013, 02:24 PM

Hi,

I think you'll need to describe in narrative form and with some comments describing the colours you expect to see for some example cells given various permutations. I can only see one link between the m6 sheet to the cuts sheet B2, but none of the CFs seem to be dependent on the M6 sheet.

Neither am I clear what you mean by the three reports pages. Only the Cuts page seems to have any formulae. Nor indeed what you regard as 'data' cells.

**ragingfred** · 03-20-2013, 02:49 PM

I'll see if I can explain this better.

The Cuts page is being designed to compare information pulled from the other three pages
and to perform a count and then compare that count.

A User will run a MIROR report (different system) and then paste special - Values the generated report into the MIROR LLT page. The Cuts page will then pull the block/pin/telephone numbers from the MIROR LLT page.

The same thing will be done for the Aquarium and M6 pages, but only Telephone numbers will be pulled over to the Cuts page.

At this point if the telephone number matches in all three reports (G7, J7, N7) the cell backgrounds will remain the same.

If the telephone number in G7 (MIROR LLT) does not match J7 (Aquarium), G7 will turn red and J7 will turn tan.

If the telephone number in N7 (M6) does not match J7 (Aquarium), N7 will turn red and J7 will turn yellow.

If there is a problem with the telephone number in both MIROR LLT (G7) and M6(N7), Aquarium(J7) will turn tan first.

The MIROR LLT and the Aquarium columns work fine.

The problem that I am having is that when the M6 report is pasted into the M6 page and the telephone numbers are pulled over to the Cuts page the cells that have telephone numbers will show red even if they match. If it is just a single 0 it works fine.

-Fred

**ragingfred** · 03-20-2013, 03:55 PM

I've found that it does work in a fashion, but the problem is that the Conditional Formatting for Column N is not updating properly when the telephone number is pasted into M6 initially.