Changing text in one cell due to number in another cell

H

hoy13

I have a workbook that charts the progress of my clients. One of m
cells automatically determines their age, and when they become olde
than six, I need another cell's text to automatically change to "AO
(standing for "Aged Out" of my program). Any suggestions?

Regards,
Jonatha
 
H

hoy13

I need it to be a type of conditional formatting. I have attached an
example of my workbook. It has a VB code that changes the row colow
based on Status. The Age row is CF'd to turn purple and BOLD when the
age reaches or exceeds six. I need the status row to automatically
change from whatever text is in it to "AO" once age is greater than or
equal to six.

Attachment filename: test.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=646826
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Further Info on changing text in one cell to to criteria of another. 4
Is Auto Expansion (i.e., wrap text) of a cell possible when thecell's contents are based on another 2
"Diagonal" cells - text-wrapping question 0
For Joey2004 et al. From OP: Re Appending Question 3
Change all text on Spread sheet 3
Copying the colour of one cell to anothers. 0
Using lookup formula using more than one cell 8
Linking Cell based on Date 8

Top