extrahotfudge
New Member
- Joined
- Apr 9, 2021
- Messages
- 10
- Office Version
- 365
- 2019
- Platform
- MacOS
Okay, so I have this Caesar Cipher set up with a spinner (not shown) and I want to make it so that when H1&I1&J1&K1&L1&M1 is a real word. I have a seperate sheet with an imported .txt file of english words, and I used VLOOKUP to determine when it was a real word. I was wondering if there is a way I could highlight H1:M1 when it is a word. I was thinging this could be done with conditional formatting but have been having trouble. When H1&I1&J1&K1&L1&M1 does not match something on the sheet of words, then G7 returns an error.
Any help is appreciated thank you!
Any help is appreciated thank you!
Cell Formulas | ||
---|---|---|
Range | Formula | |
H1:M1 | H1 | =CHAR(MOD(CODE(A1)-65+$B$5,26)+65) |
G6 | G6 | =H1&I1&J1&K1&L1&M17&M1 |
G7 | G7 | =VLOOKUP(H1&I1&J1&K1&L1&M17&M1,'English Words'!A:A,1,FALSE) |
Named Ranges | ||
---|---|---|
Name | Refers To | Cells |
'English Words'!american_english | ='English Words'!$A$1:$A$98568 | G7 |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
H1:M1 | Expression | =EXACT("H1&I1&J1&K1&L1&M1","G7") | text | NO |
G7 | Cell Value | duplicates | text | NO |