Set Critria and format filtered rows

Hello Everyone,

I am new to excel VBA and I am trying to write a macro. I am looking for some help

Here is my logic

Four worksheets

Step 1: Match active cell value on sheet 1 to equal to criteria on Sheet 2, 3 & 4 on a column

Boolean match_found = FALSE

Step 1A (Sheet2) : If match found then color code all the matching filtered rows
Set Boolean match_found = TRUE

Step 1B (Sheet2) : If match found then color code all the matching filtered rows
Set Boolean match_found = TRUE

Step 1C (Sheet3) : If match found then color code all the matching filtered rows
Set Boolean match_found = TRUE

If Boolean match_found = FALSE THEN
Color Code active cell on Sheet 1

Here is initial code draft, I cannot get the criteria to filter the right rows and color code the right cells. Can anyone please tell what am doing wrong:

Please Login or Register  to view this content.

Excel Guru is a true guru ... spot on first shot

Thank you, I leaned so much from the code too.