Automatic text & color

[Serrre]

Hi,

How do i make it so that AM5 will automatically Get a green color with the text ''Yes'' when i would tick the cell on AL5 as ✔

So when AJ5 : AK5 : AL5 cells are all ticked ✔ the cell at AM5 would say ''Yes'' . I know the green color would probably be done through conditional formatting.


Thanks for your time.

 

[Micron]

Isn't the answer contained in your other thread where you asked me how to get Yes or No in a cell instead of the evaluation of a formula (as True or False)?

 

[Serrre]

Isn't the answer contained in your other thread where you asked me how to get Yes or No in a cell instead of the evaluation of a formula (as True or False)?

Hey Micron,

It then says true/false instead of yes/no

Thanks,

 

[Micron]

It then says true/false instead of yes/no

That must mean you are not following the suggestion(s) and implementing them.

 

[Serrre]

That must mean you are not following the suggestion(s) and implementing them.

Hey Micron,

Okay, thanks for your help.

 

[Fluff]

Duplicate to: Drop down list automatic color

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.