Colour filling a cell

%3CLINGO-SUB%20id%3D%22lingo-sub-2752638%22%20slang%3D%22en-US%22%3EColour%20filling%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2752638%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%20appreciated%20any%20help%20-%20does%20an%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22excel%20fill.png%22%20style%3D%22width%3A%20720px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F310583i556EBCD15E19DC29%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22excel%20fill.png%22%20alt%3D%22excel%20fill.png%22%20%2F%3E%3C%2FSPAN%3Eyone%20know%20how%20to%20do%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2752638%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2752697%22%20slang%3D%22en-US%22%3ERE%3A%20Colour%20filling%20a%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2752697%22%20slang%3D%22en-US%22%3EThis%20can%20be%20achieve%20a%20number%20of%20ways%3A%20manually%2C%20conditional%20formatting%2C%20VBA%20to%20name%20a%20few.%20That%20image%20is%20hard%20to%20see%20but%20I%20assume%20each%20%22row%22%20is%20actually%203%20rows%20and%20they%20are%20'merged'%20on%20the%20left.%20So%20manually%20you%20can%20highlight%20the%20'middle'%20row%20and%20select%20the%20fill%20color%20you%20want.%20Using%20conditional%20formatting%20you%20can%20create%20a%20formula%20that%20would%20be%20true%20for%20that%20set%20of%20cells%20and%20define%20the%20fill%20color.%20And%20using%20VBA%2C%20well%20it%20is%20code%20and%20you%20would%20code%20it...%20i%20think%20I%2Fwe%20need%20more%20info%20about%20exactly%20what%20you%20are%20trying%20to%20achieve%20and%20what%20issue%20you%20have%20and%20it%20would%20help%20to%20have%20the%20sample%20file%20(no%20personal%2Fconfidential%20info).%20Also%20may%20help%20to%20know%20if%20you%20are%20using%20Excel%20365%20or%20what%20version%3C%2FLINGO-BODY%3E
New Contributor

Hello, Any help appreciated - does anyone know how to achieve this? Thanks in advanceexcel fill.pngyone know how to do this?

2 Replies
This can be achieve a number of ways: manually, conditional formatting, VBA to name a few. That image is hard to see but I assume each "row" is actually 3 rows and they are 'merged' on the left. So manually you can highlight the 'middle' row and select the fill color you want. Using conditional formatting you can create a formula that would be true for that set of cells and define the fill color. And using VBA, well it is code and you would code it... i think I/we need more info about exactly what you are trying to achieve and what issue you have and it would help to have the sample file (no personal/confidential info). Also may help to know if you are using Excel 365 or what version

@Nick_Eve 

You can't split an individual cell, but you can make it appear as if a cell has been split by merging the cells above it.

Merge and unmerge cells

 

Nikolino

I know I don't know anything (Socrates)