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