Formulas needed for a red "x" and green "check mark"

[Rebel17]

Hey Excel Masters!! I really wish I was better at this, but I am learning cuz of ya'll.

On the attached excel, the "Chart" page, C2 : C8, I'm trying to get a formula in those few boxes to reflect a Red X, or a Green Check Mark. I left notes in the boxes with what it is I'm looking to do. There are 3 "3 to 5" boxes, 3 "2" boxes and one "1" box. I'm looking for total of 3 formulas, one for each of the parameters mentioned in the note boxes.

Thank you in advance!

[AliGW]

Administrative Note:

We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Rebel17]

Hey Excel Masters!! I really wish I was better at this, but I am learning cuz of ya'll.

On the attached excel, the "Chart" page, C2 : C8, I'm trying to get a formula in those few boxes to reflect a Red X, or a Green Check Mark. I left notes in the boxes with what it is I'm looking to do. There are 3 "3 to 5" boxes, 3 "2" boxes and one "1" box. I'm looking for total of 3 formulas, one for each of the parameters mentioned in the note boxes.

Thank you in advance!



This is not my area of expertise and come here for help, forgive me for not knowing the terminology used amongst all of you excel experts.

[AliGW]

You edited the wrong post - please change the title in the OPENING post, and then you are good to go.

[Farley945]

Hi Rebel17,

Let me know if the attached is what you was after.

The networkdays part of the if formula works on business days.

To get the ticks and cross, go into insert symbol and wingdings. The format for the cells with the formulas also needs to be wingdings.

I then included a conditional format to find either ü (tick) or û (cross) to change the colour of the cells