Replace number with Text with the help of conditional formatting

[kankana]

Hi,

I want replace the numbers which are greater than 79 with the text "Completed". How to do that? can anyone please help?

 

[Aladin Akyurek]

Re: How to replace number with Text with the help of conditional formatting

Would you care to post a sample along with the output that goes with it?

 

[FormR]

Re: How to replace number with Text with the help of conditional formatting

want replace the numbers which are greater than 79 with the text "Completed".

Hi, if I've understood correctly you can do that with normal cell formatting - try formatting the cells with a custom format of:

[>79]"Completed";General