Conditional Formatting based on adjacent cells

[Asator]

I'm trying to apply a conditional formatting based on the value, not of the cell itself, but of an adjacent cell.

The formula I have in my conditional format (to see if the cell is blank):
=IF(OFFSET(C26,0,1)="",TRUE)

But it doesn't seem to work. Any ideas?

 

[xld]

Just use

=D26=""

 

[xld]

Try

=IF(OFFSET(C26,0,1))=""

That's not even valid.

 

[VoG]

That's not even valid.

Deleted

 

[Asator]

>> xld:
Didn't work

>> VoG:
Gives a syntax error unless I add ,TRUE for some reason. Ive done if statements with only the condition in conditional formatting before, and its worked, but it doesn't seem to work with adjacent cells >_<

Excel 2003 btw.

 

[Norie]

Asator

How didn't xld's suggestion work and what in words is the condition for the formatting?

Is it only one cell you want to format?

 

[Asator]

with =d26="" in the conditional format for c26, and d26 blank, the format is not applied. I tried putting some stuff in d26, then deleting it. No change.

I then tried going at it a different way, by setting "not equal to" =d26="x". Immediately the format was applied whether or not d26 was equal to "x".

So basically, its not working

Ideally, I'd like to have a list of cells, that have a conditional format applied if the cell adjacent to it is left blank. I also have another sheet I'm working with that selects the lowest value from an array and highlights it with a conditional format. Is it possible to have that conditional format also applied to adjacent cells?
I.e.
array A1-A10, A6 is highlighted from being the lowest value. Is it possible to have it automatically format B6 as well with the same formatting, regardless of what the value in B6 is?

 

[swinglow]

I'm trying to apply a conditional formatting based on the value, not of the cell itself, but of an adjacent cell.

The formula I have in my conditional format (to see if the cell is blank):
=IF(OFFSET(C26,0,1)="",TRUE)

But it doesn't seem to work. Any ideas?

try this:

=INDIRECT(ADDRESS(ROW(),4))=""

 

[Norie]

Are you 100% sure D26 is empty?

Is the value in there a result of a formula?

 

[VoG]

Excel Workbook
	C	D
26
27	x
Sheet15

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D26	1. / Formula is =C26=""	Abc