Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic change of cells background color
I need to change a cell's background color when i type a particular
word/letter. What is the method for same? Eg: When i type "P" in a cell, background color of the cell should change to green. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Automatic change of cells background color
Dear Aswathy:
You need to use conditional formating. Pre 2008: From the format menu select conditional formating and then in the dialog box that is displayed: cell value is equal to p. On my system it is case insensitive i.e. it works for both p's (P and p). If it doesn't just add another conditon. On 2008 use the conditional formating button on the home(?) tab very much in the same manner but there are a few more options and I can't remeber the exact requirements - have a play with it and try it out. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "Aswathy" wrote: I need to change a cell's background color when i type a particular word/letter. What is the method for same? Eg: When i type "P" in a cell, background color of the cell should change to green. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel automatic background color | Excel Discussion (Misc queries) | |||
how can I conditionally change font color, or background color? | Excel Worksheet Functions | |||
change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
Change of text or background color doesn't change on the screen. | Excel Discussion (Misc queries) | |||
Change background color | Excel Discussion (Misc queries) |