I speedrun games and atm I am writing a 100% notebook / spreadsheet on all of the items for gauntlet dark legacy.

but the way I have my spreadsheet organized isn't the best. I want to have A Column cells to have full accent colors and if there's a number in Column B then it will 40% accent color if there is a cell next to it in Column A. What would the formula be for this?

I'll link the spreadsheet to give you a little bit more understanding.Gauntlet Dark Legacy 100% All Items.xlsx

Also, feel free to give me any more formatting/organizing tips. 100% is a lot of data and I'm not really close to finishing it yet.

And if you want my skype, feel free to ask me via pm.