Google sheet formatting
Budget: $30 – $250 NZD
I require a sheet which is automatically formatted as I enter a value into a cell. The formatting depends on the value in the row above.
Please refer to the file attached which shows an example in column A1 and a chart. In cell A1, the number is 20. If the number entered into cell A2 is 20 or any of the numbers in column Y, format cell grey. In cell A4, the number 36 does not appear in column H, therefore it is not formatted to be grey.
Preferably I'd like to extend the data entry column to 700 rows and be able to duplicate the column.
Thanks for your help!
Please refer to the file attached which shows an example in column A1 and a chart. In cell A1, the number is 20. If the number entered into cell A2 is 20 or any of the numbers in column Y, format cell grey. In cell A4, the number 36 does not appear in column H, therefore it is not formatted to be grey.
Preferably I'd like to extend the data entry column to 700 rows and be able to duplicate the column.
Thanks for your help!