Conditional formatting

G

Greg

Hello,

I am trying to create a spreadsheet that lists the classes I need to
take in order to graduate, and have them highlighted based on whether
or not I have completed the prerequisites (which are in the list as
well). I have a small list setup for testing, and created checkboxes
linked to cells on another sheet whether the row (class) has been
completed.
How would I go about highlighting the classes that do not have the
prerequisites met in red and the non-completed classes ready to take
in green?

Any help is appreciated.
 

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