conditional format help

[RAMU]

Dear All,

I have a workbook where I am using this formula =ABS(H5-E5)&IF(H5> E5," ↑",IF(H5< E5," ↓","")) in column K.

Now I want to use conditional format in that column.

The value which are less (generating using the above mentioned formula) will be formatted in a pattern & higher values will be in other pattern. Same "0" value remain same.

Please help providing the solution.

Regards
RAMU

 

[sumit madaan]

Can u provide the some artifical data for same....???

 

[RAMU]

Can u provide the some artifical data for same....???

Use the formula in K5 & put any value in H5 & E5.

 

[RAMU]

Dear All,

I have a workbook where I am using this formula =ABS(H5-E5)&IF(H5> E5," ↑",IF(H5< E5," ↓","")) in column K.

Now I want to use conditional format in that column.

The value which are less (generating using the above mentioned formula) will be formatted in a pattern & higher values will be in other pattern. Same "0" value remain same.

Please help providing the solution.

Regards
RAMU

Any help would be highly appreciated.
RAMU

 

[Peter_SSs]

Assuming your data starts in row 5, select K5:K?? and apply Conditional Formatting with a formula of
=H5> E5 and apply one pattern
then set a second CF rule witha formula of
=H5< E5 and apply the second pattern.

If you need more detailed help, advise which Excel version you are using and what is the first row of data.

 

[RAMU]

Assuming your data starts in row 5, select K5:K?? and apply Conditional Formatting with a formula of
=H5> E5 and apply one pattern
then set a second CF rule witha formula of
=H5< E5 and apply the second pattern.

If you need more detailed help, advise which Excel version you are using and what is the first row of data.

Dear Mr. Peter,

Wooo !!!! It works fine. thank you very much.

RAMU