Hi! I want to see if the value is entered manually or the the value is coming from my formula (vlookup). I want the cells where the value are entered manually to be colored red and no color when the value is coming from formula. Thank you.
Cell Formulas | ||
---|---|---|
Range | Formula | |
A3:A4,A6 | A3 | =VLOOKUP(B3,$D$3:$E$8,2,FALSE) |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A3:A6 | Expression | =NOT(ISFORMULA(A3)) | text | NO |