Peter Quill
Member
- Local time
- Tomorrow, 02:44
- Joined
- Apr 13, 2023
- Messages
- 30
Hello,
I just tried to utilize this function and it works great, The only problem is that if I change the color of a cell the function doesn't auto update. How can i get it to auto update?
I've created a worksheet where I'm using color to indicate if the cost of an item has been paid. If cell background color is yellow then it has not been paid if it isn't yellow then it has already been paid. My data is in a table and I'm using Excel 365
I just tried to utilize this function and it works great, The only problem is that if I change the color of a cell the function doesn't auto update. How can i get it to auto update?
I've created a worksheet where I'm using color to indicate if the cost of an item has been paid. If cell background color is yellow then it has not been paid if it isn't yellow then it has already been paid. My data is in a table and I'm using Excel 365