Excel Compare Data

%3CLINGO-SUB%20id%3D%22lingo-sub-144835%22%20slang%3D%22en-US%22%3EExcel%20Compare%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-144835%22%20slang%3D%22en-US%22%3E%3CP%3Emy%20conditional%20formatting%20does%20not%20work%20nor%20can%20I%20change%20my%20font%20colour%20or%20my%20cell%20colour%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-144835%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Ecell%20format%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%20Groups%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-144916%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Compare%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-144916%22%20slang%3D%22en-US%22%3E%3CP%3EI%20reinstalled%20office%20home%202016%20after%20it%20was%20corrupted%20but%20then%20found%20I%20could%20not%20highlight%20cells%20in%20different%20colours%20or%20change%20the%20font%20colour%2C%20nor%20could%20I%20change%20anything%20in%20conditional%20formatting%20like%20turning%20a%20cell%20green%20if%20the%20value%20was%20above%20a%20certain%20level%20sorry%20for%20not%20being%20more%20explicit.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-144875%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Compare%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-144875%22%20slang%3D%22en-US%22%3E%3CP%3EWell%20if%20we%20are%20being%20vague%20-%20mine%20is%20working%20just%20fine%20%3A)%3C%2Fimg%3E%20If%20you%20are%20looking%20for%20help%20or%20some%20troubleshooting%20steps%2C%20try%20providing%20us%20with%20some%20more%20details.%20For%20starters%2C%20what%20version%20of%20Office%20are%20you%20using%2C%20what%20are%20the%20conditions%20you%20are%20trying%2C%20any%20formulae%20involved%2C%20etc.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

my conditional formatting does not work nor can I change my font colour or my cell colour

2 Replies

Well if we are being vague - mine is working just fine :) If you are looking for help or some troubleshooting steps, try providing us with some more details. For starters, what version of Office are you using, what are the conditions you are trying, any formulae involved, etc.

I reinstalled office home 2016 after it was corrupted but then found I could not highlight cells in different colours or change the font colour, nor could I change anything in conditional formatting like turning a cell green if the value was above a certain level sorry for not being more explicit.