#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default cell fill

how do you 'partially' fill a cell with color ?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default cell fill

You don't.

Maybe add a small colored rectangle from the drawing toolbar?


Gord Dibben MS Excel MVP

On Tue, 26 Aug 2008 12:01:03 -0700, ldmjr
wrote:

how do you 'partially' fill a cell with color ?


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,058
Default cell fill

Put an AutoShape rectangle in the cell with only half the height of the cell.
Fill the AutoShape with any color. If you want to see "behind" the color,
adjust the transparency of the AutoShape
--
Gary''s Student - gsnu200801


"ldmjr" wrote:

how do you 'partially' fill a cell with color ?

  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default cell fill

xl2007 offers a lot of formatting possibilities under conditional formatting (I
think??).



ldmjr wrote:

how do you 'partially' fill a cell with color ?


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default cell fill

I, initially read that as xl12007 and thought MVPs had a very advance
version of the 12007 release. :)

Dave Peterson wrote:
xl2007 offers a lot of formatting possibilities under conditional formatting (I
think??).



ldmjr wrote:
how do you 'partially' fill a cell with color ?




  #6   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 35,218
Default cell fill

Or maybe we just use a different base date!

Tim Otero wrote:

I, initially read that as xl12007 and thought MVPs had a very advance
version of the 12007 release. :)

Dave Peterson wrote:
xl2007 offers a lot of formatting possibilities under conditional formatting (I
think??).



ldmjr wrote:
how do you 'partially' fill a cell with color ?



--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to make a cell copy the fill colour of another cell Chase Excel Worksheet Functions 1 February 21st 08 10:29 AM
How to fill a blank cell down to a filled cell Sampath Shambu Excel Worksheet Functions 2 July 4th 07 06:53 PM
How do I automatically fill a cell based on another cell in Excel SouthCarolina Excel Discussion (Misc queries) 3 January 13th 06 12:52 AM
I want to fill the cell color based upon the other cell condition sri Excel Discussion (Misc queries) 4 January 12th 06 01:47 PM
Auto-fill cell based on adjacent cell information.. sans Excel Worksheet Functions 1 October 17th 05 11:38 PM


All times are GMT +1. The time now is 07:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"