CF help required

[aparvez007]

Dear Ninjas,


I m using below formula to add up & down icon in Col O4

=ROUND(F4,2)&" "&IF(F4>E4,"▲","▼")


using below formula in CF but not working.


=VALUE(LEFT(O4,FIND(" ",O4)-1))>N4

CF Format Blue bold Italic.


=VALUE(LEFT(O4,FIND(" ",O4)-1))<N4

CF Format Red Bold Italic.


Thanks

 

[vijaySharma]

aparvez,


This is working fine for me on Excel 2010, I have just modified the actual cells.


Could you post your sheet for us to look at.


~VijaySharma

 

[aparvez007]

how to post the Sheet.

 

[NARAYANK991]

Hi Parvez ,


Your two CF formulae should be :


=VALUE(LEFT(O4,FIND(" ",O4)-1))<E4


=VALUE(LEFT(O4,FIND(" ",O4)-1))>E4


since your values are in E4 and F4 ; I am assuming that N4 does not have anything of relevance to the CF.


Narayan

 

[aparvez007]

Hi Narayan,


Now working fine. Thanks.


Actually i took the value in N4 from E4 using round(e4,2) thats why i m giving N4 reference...


Thanks vijay & Narayan...