I've been trying all day to come up with a Conditional Formatting Formula that will compare the text in Column A to the text in Column C and highlight the cell in Column C if any of my queries are not met.
Here's what I'm expecting to see...
If Column A equals text “Basic A”, then I expect to see the text “Tier ASEC” in Column C
Or, if Column A equals text “Basic B”, then I expect to see the text “Tier BSEC” in Column C
Or, if Column A equals text “Basic C”, then I expect to see the text “Tier CSEC” in Column C
Or, if Column A equals text “Basic D”, then I expect to see the text “Tier DSEC” in Column C
Or, if Column A equals text “Basic E”, then I expect to see the text “Tier ESEC” in Column C
Or, if Column A equals text “Basic F”, then I expect to see the text “Tier FSEC” in Column C
If Column C isn’t showing the correct text (based on what’s in Column A), then I want the Conditional Formatting to just highlight the cell in Column C so I can investigate. (I don’t want the formula to insert the correct text or modify any text on the spreadsheet.)
I’ve tried multiple IF formulas combined with ANDs and I even tried some ORs, but I can’t create anything that works. I would appreciate anything that you are able to suggest. (I could post my attempts at creating this formula so that you know I've tried, but they are quite long, I think the additional text would just muddy the water -- and we already know mine don't work. ) Thank you!
Using Microsoft 365, Win 10
Here's what I'm expecting to see...
If Column A equals text “Basic A”, then I expect to see the text “Tier ASEC” in Column C
Or, if Column A equals text “Basic B”, then I expect to see the text “Tier BSEC” in Column C
Or, if Column A equals text “Basic C”, then I expect to see the text “Tier CSEC” in Column C
Or, if Column A equals text “Basic D”, then I expect to see the text “Tier DSEC” in Column C
Or, if Column A equals text “Basic E”, then I expect to see the text “Tier ESEC” in Column C
Or, if Column A equals text “Basic F”, then I expect to see the text “Tier FSEC” in Column C
If Column C isn’t showing the correct text (based on what’s in Column A), then I want the Conditional Formatting to just highlight the cell in Column C so I can investigate. (I don’t want the formula to insert the correct text or modify any text on the spreadsheet.)
I’ve tried multiple IF formulas combined with ANDs and I even tried some ORs, but I can’t create anything that works. I would appreciate anything that you are able to suggest. (I could post my attempts at creating this formula so that you know I've tried, but they are quite long, I think the additional text would just muddy the water -- and we already know mine don't work. ) Thank you!
Using Microsoft 365, Win 10