Change interior colour if cell and cell.offset 1 column is blank.

[bopsgtir]

Hi im trying to change the interior colour of a row if cells b and c are blank, i know my code only changes the one cell at the moment but i'm very new to this and trying to do it one step at a time,

This code seems to work as i would like

Please Login or Register  to view this content.

but when i add the offset it stops working, can anyone point me in the right direction

Please Login or Register  to view this content.

[Sindhus]

Hi the problem is with the 'and' operation.

Try if Cell.value = "" and Cell.offset(0,1).value = "" then

[Trebor76]

Hi bopsgtir,

Change the appersand symbol i.e. & in your code to the word And and then see how that goes.

HTH

Robert

[bopsgtir]

perfect thank you both