Monday, December 11, 2017

yogi_Conditionally Format Cells Based On Stock Availability

Google Spreadsheet   Post  #2315

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     Dec-11-2017

Add cells and change the color depending on the result (medium complexity)


I want to change the colors of the cells based on some aritmetical operations.

I need it to control the stock. Every month it is needes a different quantity of each item and I want to see with colors which months are "covered" with the current stock.
It is needed that you can indicate easily which will be the first month that you want to take in account.
Besides, I want that change the background color too with the material wich is ordered but it is still pending.

We can use an screep if it is needed

More explanation here:

Thanks in advance!!