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

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

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

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

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

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

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

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

conditional format for rows according to the result of a formu
 

Hi norman
I try but it doesn't work.B1 isn't a formula,it is a number i manually enter
in cell. it doesn't work at all. pls help me

"Norman Jones" wrote:

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

conditional format for rows according to the result of a formu
 

Hi Plainlothman,

I try but it doesn't work.B1 isn't a formula,it is a number i manually
enter
in cell. it doesn't work at all. pls help me

The conditional format condition:

= $A1$B1

Should work with either formula or numeric values.

Please give an example of the column A and B values which give you a
problem.

---
Regards,
Norman



"plainclothman" wrote in message
...
Hi norman
I try but it doesn't work.B1 isn't a formula,it is a number i manually
enter
in cell. it doesn't work at all. pls help me

"Norman Jones" wrote:

Hi PlainclothMan,

Try:

Formula Is: = $A1$B1

---
Regards,
Norman

conditional format for rows according to the result of a formu
 

hi norman
A is result of a formula which subtract to number, therefore it is number
and B is the number i enter manually.conditional format work with = $A110
but when i subsititude 10 with a cell that contain a number i doesn't work.i
want to know if the format of the number (text,general or number) is
important or not.althogh i check with all format.pls help me it's very
important for me
i have another quastion.I use today function to insert the current date in a
cell, but it update itself every day I open my worksheet .I want to know is
there a function that insert a today date in a cell and don't change and
don't change tomorrow when i open my worksheet.
best regards
plainclothman

"Norman Jones" wrote:

Hi Plainlothman,

I try but it doesn't work.B1 isn't a formula,it is a number i manually
enter
in cell. it doesn't work at all. pls help me

The conditional format condition:

= $A1$B1

Should work with either formula or numeric values.

Please give an example of the column A and B values which give you a
problem.

---
Regards,
Norman



"plainclothman" wrote in message
...
Hi norman
I try but it doesn't work.B1 isn't a formula,it is a number i manually
enter
in cell. it doesn't work at all. pls help me

"Norman Jones" wrote:

Hi PlainclothMan,

Try:

Formula Is: = $A1$B1

---
Regards,
Norman