Looking to use conditional formatting to highlight a cell when I overwrite a formula in the cell and hardcode a value
I enter a data value in A2 e.g. a product name , it recognizes that value as a match in a table and uses it in returning values in cells B2, C2 etc per lookup formulas in those cells associated with that product name value A2
Sometimes the source table will have a value to return for C2 but not B2 When the value in B2 that is returned is blank because there is nothing in the source table I want to manually input a value in the spreadsheet and fix it in the source table later
I delete the lookup formula in the cell B2 and hardcode my value for that cell
I want to use conditional formatting to automatically highlight this cell and or the text that I manually put into B2 to override the blank value that the lookup formula returned
Then I can go back and update the blank values in the source table with the new information from those highlighted cells
Thoughts
Thanks
I enter a data value in A2 e.g. a product name , it recognizes that value as a match in a table and uses it in returning values in cells B2, C2 etc per lookup formulas in those cells associated with that product name value A2
Sometimes the source table will have a value to return for C2 but not B2 When the value in B2 that is returned is blank because there is nothing in the source table I want to manually input a value in the spreadsheet and fix it in the source table later
I delete the lookup formula in the cell B2 and hardcode my value for that cell
I want to use conditional formatting to automatically highlight this cell and or the text that I manually put into B2 to override the blank value that the lookup formula returned
Then I can go back and update the blank values in the source table with the new information from those highlighted cells
Thoughts
Thanks