Auto shading

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a function or command which will automatically shade a cell whenever
data is entered into it and focus has moved elsewhere?
tia
 
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
 
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,
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparison of columns using Conditional Formatting 3
Excel 2003 bank ledger spreadsheet background fill shading 4
macro to disallow shading in certain columns 2
SUMIF based on cell shading 1
Calculating percentage of Shaded Cells in a row 1
sort 2
EXCEL FORMATTING OF WORKSHEETS WITH WITH SHADED ROWS 3
Shading a cell relative to three other cells & repeat 3

Back
Top