Hello,
First time here so I hope I am following the guidelines correctly.
I'm trying to build an excel sheet that will highlight the change in financial security ratings when a security is upgraded or downgraded each month. If it is upgraded from the previous month I would like it to be highlighted green, if it's downgraded I would like it highlighted red. I know how to do this easy formula with conditional formatting for numbers but I'm not sure how to do it with letters. I think I need to associate each rating with a number (e.g. below) that way I can use an IF > or IF < argument.
Anyone how I do this or if there is a better way?
First time here so I hope I am following the guidelines correctly.
I'm trying to build an excel sheet that will highlight the change in financial security ratings when a security is upgraded or downgraded each month. If it is upgraded from the previous month I would like it to be highlighted green, if it's downgraded I would like it highlighted red. I know how to do this easy formula with conditional formatting for numbers but I'm not sure how to do it with letters. I think I need to associate each rating with a number (e.g. below) that way I can use an IF > or IF < argument.
Anyone how I do this or if there is a better way?