J
Jock W
Is there a function or command which will automatically shade a cell whenever
data is entered into it and focus has moved elsewhere?
tia
data is entered into it and focus has moved elsewhere?
tia
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
C
CLR
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
ConditionalFormatting > then follow the menus..........
Post back with more specifics if you need any help with it.......
Vaya con Dios,
Chuck, CABGx3
J
Jock W
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,
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,
D
David McRitchie
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
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