Excel color cell if equal to another cell 133775-How to color a cell based on another cell value
Re Formula or function for IF statement based on cell color Step 1 Paste code (found at bottom) into a new module ALT F11 shortcut should open the code area Step 2 In cell O1 paste formula =InteriorColor (B1) drag formula down Step 3 In cell P1 paste formula =InteriorColor (G1) drag formula down Step 4 In cell L1 paste formula =IF (O11 reply Answer 1 / 1 Best answer approved by JeanFrançois Pillou on TrowaD Posts I'm using excel 97 or 03 and I need to create a background color if two cells match, then I need to create another color if they don't match without using conditional formtating I need to use some kind of if fomaula because I need to do this for at lease 6 numbers Use Excel Conditional Formatting To Highlight Cells 4 Examples How to color a cell based on another cell value