| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
conditional format for rows according to the result of a formula
i create a formula. i want the format of rows(for example color of the row's
content) ,which the formula is with in, change according to the result of the formula |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional format for rows according to the result of a formula
Hi PlainclothMan,
Use the desired formula result as the 'Cell Value Is' condition. --- Regards, Norman "plainclothman" wrote in message ... i create a formula. i want the format of rows(for example color of the row's content) ,which the formula is with in, change according to the result of the formula |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional format for rows according to the result of a formu
thank you very much for your response but it doesn't change format of all
cells in the rows which the formula locate "Norman Jones" wrote: Hi PlainclothMan, Use the desired formula result as the 'Cell Value Is' condition. --- Regards, Norman "plainclothman" wrote in message ... i create a formula. i want the format of rows(for example color of the row's content) ,which the formula is with in, change according to the result of the formula |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional format for rows according to the result of a formu
it just change format of the cells that their result is equal to the desired
formula result but i want format of the entire rows totally change according to desire condition "Norman Jones" wrote: Hi PlainclothMan, Use the desired formula result as the 'Cell Value Is' condition. --- Regards, Norman "plainclothman" wrote in message ... i create a formula. i want the format of rows(for example color of the row's content) ,which the formula is with in, change according to the result of the formula |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional format for rows according to the result of a formu
Hi PlainclothMan,
Assume the range to be formatted ia A1: M20, and that the formulas are in column A, then with the range selected: Formula Is: = $A1 = Your formula result If, for example, you want the conditional formatting to apply when the formula returns a value 10, then: Formula Is: = $A110 --- Regards, Norman "plainclothman" wrote in message ... it just change format of the cells that their result is equal to the desired formula result but i want format of the entire rows totally change according to desire condition "Norman Jones" wrote: Hi PlainclothMan, Use the desired formula result as the 'Cell Value Is' condition. --- Regards, Norman "plainclothman" wrote in message ... i create a formula. i want the format of rows(for example color of the row's content) ,which the formula is with in, change according to the result of the formula |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional format for rows according to the result of a formu
thank you very much
"Norman Jones" wrote: Hi PlainclothMan, Assume the range to be formatted ia A1: M20, and that the formulas are in column A, then with the range selected: Formula Is: = $A1 = Your formula result If, for example, you want the conditional formatting to apply when the formula returns a value 10, then: Formula Is: = $A110 --- Regards, Norman "plainclothman" wrote in message ... it just change format of the cells that their result is equal to the desired formula result but i want format of the entire rows totally change according to desire condition "Norman Jones" wrote: Hi PlainclothMan, Use the desired formula result as the 'Cell Value Is' condition. --- Regards, Norman "plainclothman" wrote in message ... i create a formula. i want the format of rows(for example color of the row's content) ,which the formula is with in, change according to the result of the formula |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional format for rows according to the result of a formu
hi Norman
thank for your response you wrote you want the conditional formatting to apply when the formula returns a value 10, then: Formula Is: = $A110 i want to know can i use a variable value instead of 10 that reffers to a cell value in the rows eg. cell b1 "Norman Jones" wrote: Hi PlainclothMan, Assume the range to be formatted ia A1: M20, and that the formulas are in column A, then with the range selected: Formula Is: = $A1 = Your formula result If, for example, you want the conditional formatting to apply when the formula returns a value 10, then: Formula Is: = $A110 --- Regards, Norman "plainclothman" wrote in message ... it just change format of the cells that their result is equal to the desired formula result but i want format of the entire rows totally change according to desire condition "Norman Jones" wrote: Hi PlainclothMan, Use the desired formula result as the 'Cell Value Is' condition. --- Regards, Norman "plainclothman" wrote in message ... i create a formula. i want the format of rows(for example color of the row's content) ,which the formula is with in, change according to the result of the formula |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
conditional format for rows according to the result of a formu
Hi PlainclothMan,
Try: Formula Is: = $A1$B1 --- Regards, Norman "plainclothman" wrote in message ... hi Norman thank for your response you wrote you want the conditional formatting to apply when the formula returns a value 10, then: Formula Is: = $A110 i want to know can i use a variable value instead of 10 that reffers to a cell value in the rows eg. cell b1 "Norman Jones" wrote: Hi PlainclothMan, Assume the range to be formatted ia A1: M20, and that the formulas are in column A, then with the range selected: Formula Is: = $A1 = Your formula result If, for example, you want the conditional formatting to apply when the formula returns a value 10, then: Formula Is: = $A110 --- Regards, Norman "plainclothman" wrote in message ... it just change format of the cells that their result is equal to the desired formula result but i want format of the entire rows totally change according to desire condition "Norman Jones" wrote: Hi PlainclothMan, Use the desired formula result as the 'Cell Value Is' condition. --- Regards, Norman "plainclothman" wrote in message ... i create a formula. i want the format of rows(for example color of the row's content) ,which the formula is with in, change according to the result of the formula |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formula yeilds non-number result | Excel Worksheet Functions | |||
| Excel 2007 - change size of text as a result of conditional format | Excel Discussion (Misc queries) | |||
| Conditional Format based on forumula result | Excel Discussion (Misc queries) | |||
| Conditional Formatting Against a Formula - not it's result | Excel Discussion (Misc queries) | |||
| Hide rows if formula result is zero | Excel Programming | |||
Hybrid Mode
