Conditional Formatting

[Dnyan]

Please check attached Excel file for reference.

If in option table value of days blank then there should be highlight in Item Table days column.
How can do this conditional Formatting, please suggest any formula for this?

[newdoverman]

I used a helper column D and entered in D13 and copied down.

Please Login or Register  to view this content.

Then in D3 and copied down.

Please Login or Register  to view this content.

In Conditional Formatting, I used this formula to format column B (select the cells is column B first) then chose the formatting.

Please Login or Register  to view this content.

[Dnyan]

Thanks for reply but this is very long procedure to do this. Is there any short method and also I want highlight are of Items which is blank in Option Column.

[Special-K]

Can't you just do this?

Select B3

Conditional Formatting
New Rule
Use a formula to determine...

=ISNUMBER(VLOOKUP(A3,A$13:B$20,2,0))
format as required

Use Format painter to copy to other cells

[Dnyan]

this is what I want, Thank you very much