How do I use conditional formatting for multiple rows?

J

Jim Johnson

I have a spreadsheet that tracks several orders (a different order on each
row) and I would like to use conditional formatting to shade different cells
for different conditions. When I apply the formatting to a range of cells,
the formatting is only applied if the condition is met for the entire range.
However, my orders are in different stages for each row. Do I have to apply
the formatting for each cell on each row individually or is there a faster
way to conditionally format several rows at once? Also, can I make the
formatting apply to new entries that are inserted in the middle of other rows
with the same conditions and formats?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top