Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
change a cell background colour to my own RGB colour requirements | Excel Discussion (Misc queries) | |||
Criteria - Automatic Change Font or Fill Colour | Excel Worksheet Functions | |||
Can I change the format of one cell by placing a tick in another? | Excel Discussion (Misc queries) | |||
change a cell colour when entering a letter | New Users to Excel | |||
Changing Cell Fill Colour | Excel Discussion (Misc queries) |