change event

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

Guest

Can you tell me how to change the shading in a contiguous row of cells when a change (by data entry, not calculation) is made to any one of the cells

Thank you!
 
Hi
try something like the following:
- select cells A1:X1
- goto 'Format - Conditional Format'
- enter the following formula
=COUNTA($A1:$X1)>0
- chhose a shading format
 
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

How do I get row and column of active cell to highlight? 2
Cond. Formatting, Mod(Row) and cell conditions 2
Is there a non-printing shading? 1
Searching in Excel spreadsheet 2
manually selected Excel cell formatting 1
Calculations based on cell colour 6
Selection Shading gone from 07' ??? 1
How do I prevent a user from entering data in a cell? 1

Back
Top