i want a method that A1 have any word , B1 will appear "new product" , normally i inside this formula into all B column cell =IF(A1="","","new product") . When i inside new row , the new row was inserted will not follow the formula .
I discover that conditional format and format cell will automatic follow the formula when i inside new row, i think my problem as above should be done on conditional format or format cell.
Any idea ?
thanks
Bookmarks