Conditional Formatting Q

  • Thread starter Thread starter Sean
  • Start date Start date
S

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
 
=A1<=INDIRECT("Sheet2!A1")*80%

--
---
HTH

Bob


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