I am trying to come up with a conditional formatting formula that will auto fill in a cell based on the percentage value compared with the value in another cell.
In the example below, I want the cells D3:F3 to change color based on its percentage compared with the value in B3.
Excel capacity.jpg
Bookmarks