IF/THEN function

  • Thread starter Thread starter Deno
  • Start date Start date
D

Deno

I am looking for a function that will change all the 1's
in a row into an X if a cell in the same row is marked
with an X.

B5 is the cell that may or may not have the X

IF B5 has and X, THEN all 1's in row 5 will be changed
into an X

Thank You for what ever help you can offer

Deno
 
Hi

An Excel function by definition can't change anything - not cell values, not
cell format. It only returns a result depending on input parameters. Ant
truly in cell is the formula, not the result.

So you can have an additional range with formulas, returning the value of
appropriate cell or X, depending the value of B5. Or you must have a
procedure, which changes the cell values in row, depending the value in
column B. You can start the procedure manually (shortcut or button or
Tools.Macro.Run), or you implement the code into Worksheet's Change event
and add the routine for checking the active cell (otherwise the event is
fired whenever you change anything on orksheet, what can slow you down
heavily).

Arvi Laanemets
 
Back
Top