This is a discussion on Conditional Formatting based on adjacent cells within the Excel Questions forums, part of the Question Forums category; I'm trying to apply a conditional formatting based on the value, not of the cell itself, but of an adjacent ...
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):
But it doesn't seem to work. Any ideas?
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.
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?
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?
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?
Last edited by Asator; Jun 25th, 2010 at 04:45 PM.
Are you 100% sure D26 is empty?
Is the value in there a result of a formula?
C D 26 27 x
Cell Nr.: / Condition Format D26 1. / Formula is =C26="" Abc
Excel tables to the web >> Excel Jeanie HTML 4
Please test any code on a copy of your workbook.