Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 36
Default Auto Fill Cells

Hi, Gord. Thanks for coming in on this...

I don't think I understand what pogiman means by "...create the format you
want."

If I want cell B5 to highlight when, say, a number is typed into cell F5, I
read it as meaning I select B5, go to Conditional Formatting and select the
New Rule, like you said. - But then what? I tried entering the formula
=len(B5)0 - but got a notice offering the usual advice to go to
Help!

Can you shed any more light on this for me?

So you don't think I'm being rude - this is pretty important to me - but
I'll be a while responding. I should be back in about 8 hours.

Ed


"Gord Dibben" <gorddibbATshawDOTca wrote in message
...
Ed

The actual syntax in the New Rule dialog is

"use a formula to determine which cells to format"

Last in the dialog box.


Gord Dibben MS Excel MVP

On Fri, 4 Sep 2009 09:23:18 +0100, "Ed O'Brien"
wrote:

Hi,

Sorry to be slow getting back - sleeping!

I'm afraid I have not been able to get this to work.

I am using Excel 2007 in Office Basic. I can't find the words "The
formula
is" within Conditional Formatting.

The chart I am working with contains 39 rows and 45 columns....

To help me understand a bit better ( I'm not too bright with Excel) say
cell
B5 is the cell I want to highlight (fill) in Red immediately any cell from
C5 to AS5 has data entered. (Number).

Thanks for your help and patience.

Ed


"pogiman via OfficeKB.com" <u54349@uwe wrote in message
news:9b95a7f3c0dc4@uwe...
Conditional formatting would do the trick...

Select one of the cell you want the format to appear then enter this on
conditional formatting selecting "The formula is":

=len(Current Cell Address)0 - create the format you want. This will
recognize either text or value.

Hope this helps.

Ed O'Brien wrote:
I posted this earlier but for some reason cannot see it.

Excel 97/2003 & 2007

I have a sheet which is completed daily by a user.

The rows number about 30 cells (entries) and columns relate to the days
of
the month. The day is enumerated in the first column 1 thro 31 (say).
So, to picture it, you have a blank chart with the date listed down the
left
and columns named across the top.

Does anyone know of a formula to colour fill the date cell (highlight)
if
a
number is entered in any of the cells in that row?

TIA for any help.

Ed

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200909/1





 
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
Auto Fill Cells Barbara Excel Discussion (Misc queries) 1 July 21st 08 08:04 PM
Auto fill in cells Roy[_3_] Excel Discussion (Misc queries) 0 August 17th 07 02:10 AM
Auto fill in cells Dean Excel Discussion (Misc queries) 0 August 17th 07 01:52 AM
Auto Fill a row of cells Shanny Excel Discussion (Misc queries) 1 January 11th 07 08:31 PM
Auto fill in cells Man Utd Excel Worksheet Functions 1 June 16th 05 05:32 AM


All times are GMT +1. The time now is 03:52 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"