Home

Conditional Formatting duplicating rules

sam_wright5291
Occasional Visitor

Hi there, 

 

I am working with a large data set and wanted to add conditional formatting to help with data validation. 

 

For example:

I have address that will require different fields to be filled in and I want to highlight the cells that are missing this criteria. 

 

In the postcode column I would want the cell to highlight in red if a postcode is required and the cell is blank

 

 

COUNTRYPOSTCODE
Afghanistan 
ArgentinaC1053ABR
Argentina 

 

CountryPostal Code
AfghanistanOptional
ArgentinaRequired

 

So I did this formula =IF(VLOOKUP(M7,'Address Requirements'!A:I,9,)="Required",TRUE)*AND(ISBLANK(N7)) 

 

But each row would have different criteria in terms or whether the postcode was required and if it was blank so I can't work out how to apply conditionally formatting to the column. 

 

Can anyone help? 

 

Thanks

Sam

 

1 Reply

Hi Sam

Have attached a spreadsheet that has a solution by adding a code checking column then using conditional formatting to check the result.

 

Rich

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies