|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
August 2nd, 2008, 11:08 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 
|
|
#2
August 2nd, 2008, 11:17 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
