SOLVED

Every other row is a color that I cannot get rid of & background color will not override it

%3CLINGO-SUB%20id%3D%22lingo-sub-2057328%22%20slang%3D%22en-US%22%3EEvery%20other%20row%20is%20a%20color%20that%20I%20cannot%20get%20rid%20of%20%26amp%3B%20background%20color%20will%20not%20override%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2057328%22%20slang%3D%22en-US%22%3E%3CP%3Ethis%20should%20be%20very%20easy%20but%20I'm%20not%20seeing%20it!!%26nbsp%3B%20very%20frustrating!%26nbsp%3B%20trying%20to%20get%20rid%20of%20the%20blue%20shading%20in%20every%20other%20row.%26nbsp%3B%20hitting%20the%20%22fill%22%20button%20in%20a%20white%20one%20creates%20the%20yellow%20highlight.%26nbsp%3B%20doing%20the%20same%20in%20the%20blue%20one%20does%20nothing.%26nbsp%3B%20but%20if%20you%20look%20at%20the%20cell%20-%20it%20tells%20me%20it's%20yellow.%26nbsp%3B%20but%20the%20blue%20is%20set%20up%20somewhere%20else%20giving%20it%20some%20kind%20of%20%22priority%22%20or%20%22override%22%20capability!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2057328%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2057500%22%20slang%3D%22en-US%22%3ERe%3A%20Every%20other%20row%20is%20a%20color%20that%20I%20cannot%20get%20rid%20of%20%26amp%3B%20background%20color%20will%20not%20override%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2057500%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F927850%22%20target%3D%22_blank%22%3E%40Ed_Novy%3C%2FA%3E%26nbsp%3BSelect%20the%20entire%20sheet.%20On%20the%20Home%20ribbon%2C%20select%20Conditional%20Formatting%20and%20Clear%20Rules%20(from%20entire%20sheet).%20That%20should%20do%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2065923%22%20slang%3D%22en-US%22%3ERe%3A%20Every%20other%20row%20is%20a%20color%20that%20I%20cannot%20get%20rid%20of%20%26amp%3B%20background%20color%20will%20not%20override%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2065923%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F403176%22%20target%3D%22_blank%22%3E%40Riny_van_Eekelen%3C%2FA%3EThank%20You%20VERY%20MUCH!!!!%26nbsp%3B%20I%20tried%20that%20%26amp%3B%20it%20worked%20perfect!%26nbsp%3B%20I%20never%20saw%20this%20before%2C%20the%20boss%20asked%20me%20to%20try%2C%20I%20did%20for%20an%20hour%20then%20gave%20up%20%26amp%3B%20tried%20this%20group.%26nbsp%3B%20I%20tried%20reading%20the%20rule%20language%20to%20understand%20how%20to%20do%20this%20-%20not%20happening%20any%20time%20soon!%26nbsp%3B%20Maybe%20one%20day%20but%20the%20accounting%20business%20has%20been%20nuts%20with%20SBA%20loans%2C%20etc%20this%20past%20year%20%26amp%3B%20it%20still%20is.%26nbsp%3B%20Your%20email%20went%20to%20my%20%22Junk%22%20folder%2C%20I%20just%20found%20it%20an%20hour%20ago.%26nbsp%3B%20Thanks%20again!!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

this should be very easy but I'm not seeing it!!  very frustrating!  trying to get rid of the blue shading in every other row.  hitting the "fill" button in a white one creates the yellow highlight.  doing the same in the blue one does nothing.  but if you look at the cell - it tells me it's yellow.  but the blue is set up somewhere else giving it some kind of "priority" or "override" capability! 

2 Replies
best response confirmed by Ed_Novy (New Contributor)
Solution

@Ed_Novy Select the entire sheet. On the Home ribbon, select Conditional Formatting and Clear Rules (from entire sheet). That should do it.

@Riny_van_EekelenThank You VERY MUCH!!!!  I tried that & it worked perfect!  I never saw this before, the boss asked me to try, I did for an hour then gave up & tried this group.  I tried reading the rule language to understand how to do this - not happening any time soon!  Maybe one day but the accounting business has been nuts with SBA loans, etc this past year & it still is.  Your email went to my "Junk" folder, I just found it an hour ago.  Thanks again!!