| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Auto shading
Is there a function or command which will automatically shade a cell whenever
data is entered into it and focus has moved elsewhere? tia -- Jock Waddington |
|
#2
|
|||
|
|||
|
Take a look at the Conditional Formatting feature.............Format
ConditionalFormatting then follow the menus.......... Post back with more specifics if you need any help with it....... Vaya con Dios, Chuck, CABGx3 "Jock W" wrote in message ... Is there a function or command which will automatically shade a cell whenever data is entered into it and focus has moved elsewhere? tia -- Jock Waddington |
|
#3
|
|||
|
|||
|
Chuck,
Not quite the answer. If there is an 'X' in a cell, I need the cell to the right of that one, the description cell, to automatically shade as soon as the 'X' cell has lost focus. thanks, -- Jock Waddington "CLR" wrote: Take a look at the Conditional Formatting feature.............Format ConditionalFormatting then follow the menus.......... Post back with more specifics if you need any help with it....... Vaya con Dios, Chuck, CABGx3 "Jock W" wrote in message ... Is there a function or command which will automatically shade a cell whenever data is entered into it and focus has moved elsewhere? tia -- Jock Waddington |
|
#4
|
|||
|
|||
|
Assuming that the "X" goes into Column A and that you want only
Column B to be colored then 1) With Row 1 visible, click on Column B to select it, and have cell B1 as the active cell. 2) Format, Conditional Format, Formula 1 is =$A1="x" Most worksheet formulas are not case sensitive and neither is that one. More information on Conditional Formatting in http://www.mvps.org/dmcritchie/excel/condfmt.htm --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Jock W" wrote in message ... Chuck, Not quite the answer. If there is an 'X' in a cell, I need the cell to the right of that one, the description cell, to automatically shade as soon as the 'X' cell has lost focus. thanks, -- Jock Waddington "CLR" wrote: Take a look at the Conditional Formatting feature.............Format ConditionalFormatting then follow the menus.......... Post back with more specifics if you need any help with it....... Vaya con Dios, Chuck, CABGx3 "Jock W" wrote in message ... Is there a function or command which will automatically shade a cell whenever data is entered into it and focus has moved elsewhere? tia -- Jock Waddington |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Cell Shading (based on the shading of other cells) | Excel Worksheet Functions | |||
| how can I use shading as criteria in a formula? | Excel Worksheet Functions | |||
| change cell shading whenever contents different from previous cell | Excel Discussion (Misc queries) | |||
| how do you set auto shading of cell based on percent value in exc. | Excel Worksheet Functions | |||
| excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
Hybrid Mode
