Changing text in one cell due to number in another cell

  • Thread starter Thread starter hoy13
  • Start date Start date
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
 
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
 
Back
Top