Highlight according to values

[phoztek]

Hi all,

I need help creating a formula to do the following:

In the A Column there are numbers
In the B Column there are dates
In the C Column there are dates

I tried using conditional formating with no luck.

What i want it to do is to Highlight the Numbers in the A column if:

1.- There is the same date on column C and on Column B relative to the number
2.- The Date on column B is one day after the date on Column C relative to the number

I hope that i explained myself good.

Hope someone will be able to help me.

Cheers

[canapone]

Hi, I used a condional formatting (insert-conditional formatting).

In the first condition

The formula is =B6=VLOOKUP(A6,$A$6:C6,3,0) -----> yellow

In the second condition

The formula is =B6-1=VLOOKUP(A6,$A$6:C6,3,0)----->orange

I've attached an example: hope it's clear enough.

Cheers