change event

K

KathyN

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!
 
F

Frank Kabel

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
 
Top