#1   Report Post  
Old July 22nd 09, 05:16 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2009
Posts: 1
Default In-Cell Instructions

I want to have 'in-cell' instructions (i.e. "Enter Length Here"). I want the
instructions to be in a light grey, and when the user enters their data (into
the same cell as the instructions), the number is in black. How to I get the
cell to automatically change colors from grey to black when a user enters
data?

  #2   Report Post  
Old July 22nd 09, 05:33 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2007
Posts: 11,501
Default In-Cell Instructions

Hi,

Use conditional formatting.

Select the cell then
Format|Conditional format - Cell Value is- 'Equal to'
In the input box enter your text prompt
Click format and select a light grey colour for the font - OK

Mike

"mckillmt" wrote:

I want to have 'in-cell' instructions (i.e. "Enter Length Here"). I want the
instructions to be in a light grey, and when the user enters their data (into
the same cell as the instructions), the number is in black. How to I get the
cell to automatically change colors from grey to black when a user enters
data?

  #3   Report Post  
Old July 22nd 09, 05:37 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default In-Cell Instructions

You have two easy options:

1. Insert a Comment in the cell. The comment will appear wheneven a
mouse-over occurs

2. Insert a Data Validation message in the cell. The message will appear
whenever the cell is clicked.
--
Gary''s Student - gsnu200859


"mckillmt" wrote:

I want to have 'in-cell' instructions (i.e. "Enter Length Here"). I want the
instructions to be in a light grey, and when the user enters their data (into
the same cell as the instructions), the number is in black. How to I get the
cell to automatically change colors from grey to black when a user enters
data?

  #4   Report Post  
Old July 22nd 09, 05:47 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 5,942
Default In-Cell Instructions

The attached link describes doing exactly what you have asked but it is a bit
fussy to do...

http://spreadsheetpage.com/index.php...e_camera_tool/

Alternatively you can look at using conditional fomrats and data validation
to highlight the cells necessary to be input and validation to give
instructions.

My personal preference is to use colour to denote meaning. All of the cells
that I expect the user to use are left white. Everything else is coloured (in
subdued shades) to organize the page into logical groupings.
--
HTH...

Jim Thomlinson


"mckillmt" wrote:

I want to have 'in-cell' instructions (i.e. "Enter Length Here"). I want the
instructions to be in a light grey, and when the user enters their data (into
the same cell as the instructions), the number is in black. How to I get the
cell to automatically change colors from grey to black when a user enters
data?

  #5   Report Post  
Old September 10th 18, 10:56 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2018
Posts: 1
Default In-Cell Instructions

On Wednesday, July 22, 2009 at 9:46:02 PM UTC+5:30, mckillmt wrote:
I want to have 'in-cell' instructions (i.e. "Enter Length Here"). I want the
instructions to be in a light grey, and when the user enters their data (into
the same cell as the instructions), the number is in black. How to I get the
cell to automatically change colors from grey to black when a user enters
data?


Hey Try using this script:

function format_1() {
var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByNa me("Sheet1");
var range = sheet.getRange("C20:H20");
if (range.isBlank()) {
range.setValue("Enter Length Here").setFontColor("grey");
}
}
function onEdit(e){
var range = e.range;
if(range.getRow() == 20 && range.getColumn() = 3 && range.getColumn() <= 8){
var value = range.getValue();
if(range.isBlank()){
range.setValue("Enter Length Here").setFontColor("grey");
}
else if(!range.isBlank() && range.getValue() != "Enter Length Here"){
range.setFontColor("black");
}
}
}


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 do I add typing instructions to an Excel cell? wjs2ps Excel Discussion (Misc queries) 3 May 28th 09 03:31 PM
Template Instructions dd53 Excel Worksheet Functions 4 May 18th 09 10:21 PM
can i use one workbook to perform instructions i another des-sa[_2_] Excel Discussion (Misc queries) 1 May 21st 08 04:48 PM
is there a way to do 4 instructions with one macro des-sa[_2_] Excel Discussion (Misc queries) 1 May 14th 08 09:37 PM
click on cell and get instructions, how do you set it up? Ellie05il Excel Discussion (Misc queries) 2 September 13th 07 03:39 PM


All times are GMT +1. The time now is 02:03 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017