Conditional Formatting

[13lack13lade]

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?

[ajryan88]

Hi,

Assuming that your ranges START at B2, highlight all rows that you want conditionally formatted in column B, and then use this formula:

Please Login or Register  to view this content.

and then choose your formats.

Just a note on the second condition also...I have used "=1", but this assumes that you have values formatted as percentages (i.e. 1 = 100%), but if you have text that says "100%", then change this condition to

Please Login or Register  to view this content.

Hope this helps

[13lack13lade]

It would of worked! except for 1 minor issue....

'You cannot use references to other worksheets or workbooks for Conditional Formatting critera'

thanks anyway!

[L-Drr]

If that's the case, I guess the only thing you can do is create a duplicate of your B, H and I columns from your Ready to HDC sheets (='Ready to HDC'!B1 and drag down etc.) to the sheet where the formatting is done