On Jun 20, 1:57*pm, "dazoloko via OfficeKB.com" <u43760@uwe wrote:
Dear All
Is it possible to colour a range of cells based upon a check box ie if it is
checked, a particular range is green or if its unchecked the range is red ?
Thanks in anticipation
D
--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/ms-excel/200806/1
I think u can do it via
Vb. U can check if the checkbox ischecked.
then u can format the range and specify the color