Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 22nd 07, 11:42 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 1
Default how do I Change cell fill colour by placing letter in it

I have a spreadsheet which has some cells formatted to change their fill
colour to grey if the letter N is entered. I cannot figure out how to do
this so that I can use it on another spreadsheet, any ideas??

  #2   Report Post  
Old July 22nd 07, 11:46 AM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 70
Default how do I Change cell fill colour by placing letter in it

Conditional formatting.

Spreadsheetdimwit wrote:

I have a spreadsheet which has some cells formatted to change their fill
colour to grey if the letter N is entered. I cannot figure out how to do
this so that I can use it on another spreadsheet, any ideas??


  #3   Report Post  
Old July 22nd 07, 12:10 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 390
Default how do I Change cell fill colour by placing letter in it

In , garfield-n-odie [MVP]
spake thusly:

Spreadsheetdimwit wrote:

I have a spreadsheet which has some cells formatted to change
their fill colour to grey if the letter N is entered. I cannot
figure out how to do this [. . .]


From the Menu: Format / Conditional Formatting...

Set Condition-1 to: Cell Value Equal To ="N"

Or maybe you'll want "Greater Than or Equal To" instead of "Equal To".
Then you can have the cell value *start* with "N" and have it gray,
such as the value "N/A" or "NA", etc.

--
dman

  #4   Report Post  
Old July 22nd 07, 01:20 PM posted to microsoft.public.excel.misc
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 10,124
Default how do I Change cell fill colour by placing letter in it

Select the cell with the conditionformatconditional formatting and you
will see

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Spreadsheetdimwit" wrote in
message ...
I have a spreadsheet which has some cells formatted to change their fill
colour to grey if the letter N is entered. I cannot figure out how to do
this so that I can use it on another spreadsheet, any ideas??




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
change a cell background colour to my own RGB colour requirements Stephen Doughty Excel Discussion (Misc queries) 4 June 16th 06 01:08 PM
Criteria - Automatic Change Font or Fill Colour stevembe Excel Worksheet Functions 4 October 4th 05 04:43 AM
Can I change the format of one cell by placing a tick in another? garygrung Excel Discussion (Misc queries) 2 September 13th 05 04:29 PM
change a cell colour when entering a letter paul42770 New Users to Excel 2 June 27th 05 08:58 PM
Changing Cell Fill Colour Nick Excel Discussion (Misc queries) 4 December 6th 04 10:05 PM


All times are GMT +1. The time now is 01:50 AM.

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