Re: How to test an adjacent cell for blank in conditional formatting

In code?

dim myCell as range
set mycell = active***.range("b99")
if isempty(mycell.offset(0,1).value) then
msgbox "the cell to the right is empty--no formula, no nothing!"
end if

If you want to check to see if it contains a formula that evaluates to "" or is
empty:

if mycell.offset(0,1).value = "" then



davegb wrote:

I want to test to see if an adjacent cell is blank or not to change
the formatting of the cell in question. I would guess it might involve
the Offset property. Does anyone know how to do this?

Thanks!

--

Dave Peterson
.