Conditional formatting question Highlighting overwritten cells with formulas

asorifice

New Member
Joined
Jul 14, 2021
Messages
13
Office Version
  1. 365
Platform
  1. Windows
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
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
I think that you will have difficulty getting Conditional Formatting to know & remember what was in a cell previously, but perhaps this might help?
 
Upvote 0

Forum statistics

Threads
1,223,903
Messages
6,175,284
Members
452,630
Latest member
OdubiYouth

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top