I have a workbook in Google Sheets and it is for a schedule for my company so I have a few sheets in my workbook that have the days of certain weeks and then one more tab that has inventory information. What I am looking to be able to do is type in the WO number into one of the week sheets and then type that into the WO spot on the inventory tab and in that same row on the inventory sheet there will be check boxes we click on that will change the color of the cell on the schedule so we can see what's happening with the WO on the schedule and don't have to shift over to inventory sheet every time we want to see where a house is at in the process.

I hope that make sense and I greatly appreciate the help!

Here is a link to it:

  • 1
    Welcome to Web Applications. It's very likely that what you are looking for is "conditional formatting". We already have several questions about this, please review them and checkout the official help center. If you need further help, please show what you tried and add a brief description of your search efforts as is suggested in How to Ask. – Rubén Apr 2 at 2:09
  • Welcome. I hope that makes sense Unfortunately there is no data in your spreadsheet that could be used to show the result that you are trying to achive. I suggest that you enter some test data, and then include a sheet that shows what a successful formatting outcome would look like. – Tedinoz Apr 2 at 13:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.