Conditional Formatting based on 2 sets of criteria?

[Ian1976]

Hi,

I'm using this formula...

=IFERROR(VLOOKUP(AG3,A2:T89,200)," ")

Is there a way to also check if the text in AG3 starts with 319 and the result returned from A2:T89 was >499 then colour the result if conditons are met in red?

Thanks

 

[Fluff]

As this is a new question, please start another thread

 

[Ian1976]

Will do sorry!