Basically i have a very basic work order, name, address, phone number spreadsheet to keep track of work (clients, jobs, dates, locations) . The are a few drop down menus. 1 drop down menu has 3 options and depending which option is chosen the row is highlighted a different color. What i would like is when i complete a certain cell, or press a button or however works, i want the next row to become active with all the same drop down menus and highlighting conditions. I would like this to happen everytime the previous row is complete.
After defining my data as a table i found that the conditional formatting was applied to the whole table.
rule: if n2="low"then(highlight a2:n2 yellow)
after defining as a table and adding 26 rows....
rule: if n2="low"then(highlight a2:n26 yellow)
so thats not working.
also i dont want to have to add rows. Idealy i want them to come up on their own for ease of use for other people.
any ideas welcome.
thanks in advance
After defining my data as a table i found that the conditional formatting was applied to the whole table.
rule: if n2="low"then(highlight a2:n2 yellow)
after defining as a table and adding 26 rows....
rule: if n2="low"then(highlight a2:n26 yellow)
so thats not working.
also i dont want to have to add rows. Idealy i want them to come up on their own for ease of use for other people.
any ideas welcome.
thanks in advance