Hello
I want to apply a format to a line based on an input, let's say I have 5 rows and 5 columns of data I want that if I type "x" in the column number 6, lets say "F1" the format of row a1 to e1 change and so.
it's there any way to do that in excel, or a macro that identifies in all the cells that I've typed "x" and format the corresponding lines?
Thanks
Miguel
I want to apply a format to a line based on an input, let's say I have 5 rows and 5 columns of data I want that if I type "x" in the column number 6, lets say "F1" the format of row a1 to e1 change and so.
it's there any way to do that in excel, or a macro that identifies in all the cells that I've typed "x" and format the corresponding lines?
Thanks
Miguel