Hi
try the following:
- goto 'View - toolbars' and check 'Controls'
- add a checkbox (drag it to your sheet)
- right-click on the checkbox, choose 'Properties' and define the
linked cell (R8C7)
- uncheck the 'Design mode'
- select cell R8C8
- goto 'Format - Conditional Format'
- enter the formula
=R8C7
and choose a format for the case the checkbox is checked
--
Regards
Frank Kabel
Frankfurt, Germany
Hi to everybody.
I m new to Excel so :
How can I create step by step a Checkbox , tie it to a cell (R8c7),
and when I check it make a red color unlight in an adiacent cell in
the same row (r8c8)?
Suppose that the cells are R8c7 and r8c8.
Thank you
---
Message posted from http://www.ExcelForum.com/