Conditional Formatting Q

[Sean]

What formula could I use within CF to express the following

If A1 in Sheet1 is less than or equal to 80% of the value of A1 in
Sheet2, then change text colour (I know how to format, just not sure
of the syntax of the formula)

Thanks

 

[Bob Phillips]

=A1<=INDIRECT("Sheet2!A1")*80%

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)