Quote Sheet Formula Problem

[rantam1]

I'm attemping to formulate Column E (TPMS) and F (Road Hazard) a true or false. Meaning if a cell in column E or F was clicked then that would mean the cell was True and then a check or bullet would appear. And if it was not checked it would be False and be left blank. Then again if a cell in E and/or F was clicked Then Columns M and N would calculate the TMPS cost and/or Road Hazard Cost. Right now, the spreadsheet still calculates M and N no matter what. That’s the complicated part and that is where the formatting get’s over my head.

I think I need an "If" comand in all four columns, but I can't seem to write them appropriately. Any suggestions would be so very appreciated.

[zbor]

What do you want those lights to show?

Clicked ot not clicked or groups for whole E16:F22 range like now?

[rantam1]

Sorry, I just got back to you. thought I'd get someting in email that I received a reply. Checked back and saw your replay back on 2/10. Well, they don't have to be lights. In fact, I'd like to make them check marks or tics and I'd like those symbols to show up only when clicked. All I want is a way to click in the TPMS or Road Hazard column and a tick mark or some kind of symbol to show up and when that happens then I want column M and N to calculate with my Quantity column. I don't think it is a range really. If I can nail down the formulas for that first row of data then I should be able to copy that down throught the rest of the spreadsheet. If you have a suggestion I would really really appreciate it as I have been stumped on this for a long time.

[rantam1]

I think may be I need to ask for correct Macros in my check Box. So for I have check boxes in Columns E and F, Which is TMPS and RH. The macro I have written so far reads:
Private Sub Worksheet_BeforeDoubleClick _
(ByVal Target As Range, Cancel As Boolean)

Target.Font.Name = "Marlett"
If Target.Value = vbNullString Then
Target.Value = "a"
Else
Target.Value = vbNullString
End If

End Sub

But I think I need another maco after it that explains that if The check boxes in one or the other or both cells are clicked then Cells in Column M and N are then calculated. I actually found macro on a help site and copied it to create what I need for my check box.I would be so relieved to find help in finally finishing this form/spreadsheet. Thanks so much for any help you can give me.

[rantam1]

If anyone can help with this issue, I'd greatly appreciate. I so need to complete this quote sheet today. I just don't know if I need to use a check box or a tic and how I can incorporate either one into either a formula of if I need to use a macro. Please, please, please, help.