Help needed with writing an If/Then conditional formula regarding formatting

[judybthe1]

Hi All,
I am new to this site as was driven here because I am officially stumped! If it's even possible, I'd like to create a formula that says:
"If cell H4 contains 'HW' (the letters HW), then insert a '•' (bullet or check mark) in cell I4" Can this even be done? Thank you in advance for your input.

[adhawan06]

Hi judy,

type the following formula in I4 - "=IF(H4="HW","●","")"

[gmr4evr1]

Not sure if you can put a bullet or check mark, but you can put In text like Yes or No....or any other text you want. IF you don't know how, place the following formula in cell I4

Please Login or Register  to view this content.

[FDibbins]

Hi welcome to the forum

Perhaps something like this...
=IF(B13="hw","l","")
and then format as wingdings

[gmr4evr1]

adhawana06,

type the following formula in I4 - "=IF(H4="HW","●","")"

How did you get the Bullet in there?

[judybthe1]

That was fast and it worked! Thank you. So now, of course, I want to go a bit further, how do I add an "or" clause." Same as before but now it will read... If cell H4 contains 'HW' (the letters HW), OR HW-COL, then insert a '•' (bullet or check mark) in cell I4"

[judybthe1]

The bullet is Option 8 (on a mac)

[judybthe1]

Thank you. I look forward to learning a lot!

[adhawan06]

adhawana06,


How did you get the Bullet in there?

Hi gmr,

Keep holding ALTkey then press 7 ALT+7 (ASCII (hex).

sorry for replying late.

[adhawan06]

Hi Judy,

Type the following formula - "=IF(OR(H4="HW",H4=""HW-COL","●","")"

[FDibbins]

The more traditional method...
=IF(OR(B13="hw",B13="HW-COL"),"l","")
or you could opt for this 1...
=IF(SUM(COUNTIF(B13,{"hw","HW-COL"})),"l","")

[gmr4evr1]

Unfortunately, the ALT key + 7 does not work for me. When I press the ALT key, 7 isn't an option for me.

[adhawan06]

Unfortunately, the ALT key + 7 does not work for me. When I press the ALT key, 7 isn't an option for me.

Hi gmr,

this function will work only then when you use the number keyboard (right side on your standard keyboard) with ALT key. If still not able to find out then go to Insert in Menu tab and then under "Symbols" category, select symbol there you have all the symbols available. let me know if still it does not work for you

[gmr4evr1]

Well sum-gun, it works great when you do it the RIGHT way! Thanks a bunch!