Home

color cell according to function

%3CLINGO-SUB%20id%3D%22lingo-sub-1066644%22%20slang%3D%22en-US%22%3Ecolor%20cell%20according%20to%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1066644%22%20slang%3D%22en-US%22%3E%3CP%3EJust%20upgraded%20(maybe%20not%20the%20correct%20word....)%20from%20Excel%202010%20to%20Excel%20365.%20In%202010%20I%20had%20the%20choice%20of%20coloring%20a%26nbsp%3B%20cell%20according%20to%20its%20function%20-%20normal%20was%20clear%2C%20formula%20was%20light%20grey%20and%20there%20were%20other%20colors%20that%20I%20could%20chose%20from%20to%20highlight%20cells.%20It%20was%20on%20the%20Home%20tab%20and%20was%20actually%20a%20pull%20down%20with%20lots%20of%20different%20colors%20in%20it.%20It%20was%20not%20the%20Font%20coloring%20tab.%20Where%20has%20it%20gone%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1066644%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1066698%22%20slang%3D%22en-US%22%3ERe%3A%20color%20cell%20according%20to%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1066698%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F488960%22%20target%3D%22_blank%22%3E%40Rushd45%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20mean%20styles%20they%20are%20still%20at%20Home%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20609px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F161839i08748943D3760567%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3Ebut%20could%20be%20shorten%20to%20one%20icon%20depends%20on%20your%20window%20size%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20301px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F161840iE7D597A31E46BDED%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22image.png%22%20title%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Rushd45
Occasional Visitor

Just upgraded (maybe not the correct word....) from Excel 2010 to Excel 365. In 2010 I had the choice of coloring a  cell according to its function - normal was clear, formula was light grey and there were other colors that I could chose from to highlight cells. It was on the Home tab and was actually a pull down with lots of different colors in it. It was not the Font coloring tab. Where has it gone?

1 Reply

@Rushd45 

If you mean styles they are still at Home

image.png

but could be shorten to one icon depends on your window size

image.png

Related Conversations
not able to type number and text in same cell?
Deleted in Excel on
2 Replies
A problem with the Zoom level of a Tab
Tavory in Discussions on
9 Replies
Which formula to use
Ramon Haagen in Excel on
2 Replies
Automatic coloring sunburst chart
stefan645 in Excel on
2 Replies
function talking to table storage
donquijote in Compute on
0 Replies
Calculated column help
gopalaraoa in SharePoint on
1 Replies