Hi
I am looking to validate Australian Postal Codes (column I) based on the state value in column H with conditional formatting if possible
The postcode of each state must start with the number as listed below. So, If State = SA and Postcode does not start with 5, highlight the cell. Or If State = QLD and Postcode does not start with 4, highlight the cell etc.
SA 5,
QLD 4
NSW 2
VIC 3
WA 6
TAS 7
ACT 2
NT 0
Thanks in advance
I am looking to validate Australian Postal Codes (column I) based on the state value in column H with conditional formatting if possible
The postcode of each state must start with the number as listed below. So, If State = SA and Postcode does not start with 5, highlight the cell. Or If State = QLD and Postcode does not start with 4, highlight the cell etc.
SA 5,
QLD 4
NSW 2
VIC 3
WA 6
TAS 7
ACT 2
NT 0
Thanks in advance