Conditional Formatting Q
 

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

Conditional Formatting Q
 

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

--
---
HTH

Bob


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



"Sean" wrote in message
...
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