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

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

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

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