Formula or Macros

[alexjames1990]

Hi,

I’m using Webdings. A gives you a green tick and R gives you a red cross. Is there a formula or macros I can use that automatically generates a tick or cross in columns N, O, P, Q, R etc?

Column N is one period, column O is the second period etc and I want it to do a calculation based on the results in column L.

 

[RobP]

If you are using O365 excel, one option could be to insert picture of a tick into any spare cell (say L1 in this case), and a picture of a cross in cell M1 using

Insert > Pictures > Place in Cell >stock images (and search for Tick/cross Icons).

Then you can do your calculation in N5 like thus =IF("formula"= TRUE,L1,M1) so if its correct, it copies L1, incorrect copies M1.

You can preformat the colours of the icons to red / green if you wish ..

If you are using Office 2021 or previous, then sadly you don't have this particular solution as an option - but there may be other ways people here can help with.

Rob

 

[alexjames1990]

If you are using O365 excel, one option could be to insert picture of a tick into any spare cell (say L1 in this case), and a picture of a cross in cell M1 using

Insert > Pictures > Place in Cell >stock images (and search for Tick/cross Icons).

Then you can do your calculation in N5 like thus =IF("formula"= TRUE,L1,M1) so if its correct, it copies L1, incorrect copies M1.

You can preformat the colours of the icons to red / green if you wish ..

If you are using Office 2021 or previous, then sadly you don't have this particular solution as an option - but there may be other ways people here can help with.

Rob

Hi Rob,

Thanks for your message. Is there anything else you can think of? I’ve attached a snippet below - for example; one entry in column L, row 5 has 1 period so it would just have one green tick then row 6 has 2 periods so 2 x ticks?

 

[Peter_SSs]

Welcome to the MrExcel board!

Wondering why you have "Prefer not to say" for your version? As you can see from Rob's post, options that are available can depend on the version so it makes it hard for helpers if they do not know what options are available to you.

Anyway, if the columns are formatted as Webdings, try this formula in N5 and copy across and down

=IF(COLUMNS($N:N)<=$L5,"a","r")

 

[alexjames1990]

Welcome to the MrExcel board!

Wondering why you have "Prefer not to say" for your version? As you can see from Rob's post, options that are available can depend on the version so it makes it hard for helpers if they do not know what options are available to you.

Anyway, if the columns are formatted as Webdings, try this formula in N5 and copy across and down

=IF(COLUMNS($N:N)<=$L5,"a","r")

Thank you

 

[Peter_SSs]

You're welcome.