| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Cell Color Changes
I have a copy of spreadsheet that changes cell colors when I type in a
particular word. I would like to know what steps it takes to get that done. Thanks for the help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Color Changes
You can use conditional formatting, but if you are using excel pre 2007 you only get to write 3 conditions, for a great explanation check out Bob Phillips site http://www.xldynamic.com/source/xld.CF.html it doesn't come better than that! masweets;188277 Wrote: I have a copy of spreadsheet that changes cell colors when I type in a particular word. I would like to know what steps it takes to get that done. Thanks for the help. -- Simon Lloyd Regards, Simon Lloyd 'The Code Cage' (http://www.thecodecage.com) ------------------------------------------------------------------------ Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=51923 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Color Changes
That is conditional formatting you can remove it if not required. Conditional
formatting is done when there is a requirement of formatting the cells based on certain conditions. We can conditional formatt these cells for a maximum of three conditions. -- _______________________ Click "Yes" button if it helps ________ Thanks Suleman Peerzade "masweets" wrote: I have a copy of spreadsheet that changes cell colors when I type in a particular word. I would like to know what steps it takes to get that done. Thanks for the help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Cell Color Changes
Thanks for the help! Bob Phillips response and yours were just what I needed
to complete the project! Mike "masweets" wrote: I have a copy of spreadsheet that changes cell colors when I type in a particular word. I would like to know what steps it takes to get that done. Thanks for the help. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can't format cell color/text color in Office Excel 2003 in fil | Excel Discussion (Misc queries) | |||
| Make text color match cell color with macro? | Excel Discussion (Misc queries) | |||
| Excel: Syntax to change cell color based on color of another cell | Excel Worksheet Functions | |||
| Can't format cell color/text color in Office Excel 2003 in files . | Excel Discussion (Misc queries) | |||
| Default Border, Font Color, and Cell Background Color | Excel Discussion (Misc queries) | |||
Linear Mode
