Katamefxg

As we can see below, column C has numbers with some background color Now go to the cell where we need to see the output and type the "=" sign (Equal) And search and select the SUBTOTAL function as shown below Now, as we need to sum the numbers, so from the dropdown of SUBTOTAL Function, select 9, which is for sumLet's assume you wish to run a formula in cell E4, and the formula is based upon the background colour in cell D4 (or 4,4) being either yellow or not yellow You can overwrite the formula written earlier in cell E4 and replace it with the following code and then push return Note the "If (CellColour (4,4)=6"On the home tab, in the Styles subgroup, click on Conditional Formatting→New Rule Now select Use a formula to determine which cells to format option, and in the box type the formula D3>5; How To Use Conditional Formatting With If Function In Microsoft Excel Excel formula based on cell color without vba