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

Imagine the cells you want to test are in column A and you want to
change the format in column B. Highlight all the cells in column B,
with B1 as the active cell. Then Format | Conditional Formatting and
in the first box select Formula Is from the pull-down, then in the
next box enter this formula:

=A1=""

Then click the format button, click the Patterns tab and choose your
colour. Click OK twice and the CF is set for all the cells you
highlighted.

Hope this helps.

Pete

On Mar 28, 2:40 pm, "davegb" <dav...@xxxxxxxxxxxxxx> wrote:
On Mar 28, 6:08 am, Dave Peterson <peter...@xxxxxxxxxxxxxxxx> wrote:





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

Thanks for your reply, Dave. I know how to do it in code, I want to
know how to do it in conditional formatting.- Hide quoted text -

- Show quoted text -


.

Loading