conditional formatting??

  • Thread starter Thread starter ice_cool
  • Start date Start date
I

ice_cool

is it possible to make the conditional format update a combo box if
new piece of data is entered into a clolumn of cells.

say for example i have cells A1 through A5 with data in and i add a ne
piece of data into cell A6.

Is there any way that i can set the conditional formatting up with V
to update a combo box with this new piece of data included
 
Hi

Conditional format doesn't change values in cells! It changes cell format,
i.e. color, shrift, bolding - it changes how cell or it's contents are
displayed.

When you used Data.Validation.List to make the cell look like a combo, then
here is an example how to achieve what you want.

Create a dynamic named range (Insert.Name.Define) from your list on
worksheet. P.e. your list is on sheet Sheet1 in column A. Create a named
range p.e. MyList
=OFFSET(Sheet1!$A$1,,,COUNTIF(Sheet1!$A:$A,"<>"),1)
Now set for cell with dropdown Data.Validation.List source to '=MyList', and
it's done. NB! Your list on Sheet1 must always remain contignous - every gap
leaves out one element.

When your list on Sheet1 has header p.e. in cell A1, then define the named
range as
=OFFSET(Sheet1!$A$2,,,COUNTIF(Sheet1!$A:$A,"<>")-1,1)

Btw, defining a list as named range is only way to get validation list
source from another sheet.
 
Back
Top