basicaly i have created a rule in one cell to reflect a certain outcome of other cells and i need to recreate this rules about 30 or so times with the next lines of information.
my question is, is their a easy way to replicated this formula to pertain to the next set of information or do i have to go through the long process of recreating the rule for each set of information?
edit: so i added the attacted spreadsheat. u can look at the rules to see what its suppose to do. the cells that are green in color have 2 formulas in them. one to make it turn red if its false and another to turn green if its true.
i need to do this for the entire 4 times in each row for about 31 rows
Bookmarks