How to change worksheet color based on its condition
Dear Experts,
I'm truly beginner on spreadsheet, I want to make conditions on sheets, the worksheet background color should turns to red if the data on the sheet is uncompleted. If the data on the sheet is completed, the worksheet background color should turns to green.
I attach the example files regarding to my question.
Any responds from you would be appreciated.
Regards,
Saesaria
| Attachment | Size |
|---|---|
| uncompleted sheet.png | 287.29 KB |
| completed sheet.png | 314.4 KB |
| file.xlsx | 47.15 KB |
use conditional
use conditional formatting... highlight the worksheet cells, and create a formula to define what colour to hace the cells... have a look at this: