Home

Help with Conditional formatting

Lt1205
Occasional Visitor

I have a template that I've created, which V-lookups data from one spreadsheet into the template.

 

I want to set up some conditional formatting that will highlight if any of the formulas in any cell change from being a formula (and displaying the value that the formula looks up) to being a value.

For example, one of the cells is for a price, and is currently looked up from another spreadsheet. If the person completing the template overwrites that value in the price cell, I want it to turn Blue (let's say).

 

Can anyone suggest anything? Thanks :)

1 Reply

 

Use a formula to determine which cells to format, then this formula (Replace A1 with the cell you are checking of course), just check to see that it is a formula containing Vlookup:

 

=IFERROR(FIND("VLOOKUP",FORMULATEXT(A1)),0)=0

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies