Hey Guys need some help,
I have an array im trying to do some conditional formatting on.
i have 2 worksheets 1 with data im trying to get the conditional formatting to highlight using the other one to feed the values.
I cant quite figure out the formula but it should be something like IF(B='Ready to HDC'!B & 'Ready to HDC'!H2 = 100% & 'Ready to HDC'!I2 <> 0) then turn green else do nothing.
but its not working, any idea on the correct way to syntax this?
Bookmarks