Unique excel formula
Closed
Verron

Aug 26, 2009 at 08:14 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021  Aug 26, 2009 at 08:43 PM
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021  Aug 26, 2009 at 08:43 PM
Related:
 Unique excel formula
 Date formula in excel dd/mm/yyyy  Guide
 Number to words in excel formula  Guide
 Excel grade formula  Guide
 Logitech formula vibration feedback wheel driver  Download  Drivers
 Transfer data from one excel worksheet to another automatically formula  Guide
1 response
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Aug 26, 2009 at 08:43 PM
Aug 26, 2009 at 08:43 PM
your problem is not completely clear
I am rephrasing it
suppose your cell is C1
if B1=0 then c1is 260/k1
if b1 is not 0 then c1 is (B1*260)/k1
if C1 is greater than 2 then c1 is colored red.
if this is so there is no easy formula (unless you want a macro).
but you can do one trick
in C1 copy paste this formula
=(IF(B1=0,260/K1,B1*260)/K1)
now conditionally format C1
select C1 click format(menu) conditonal format
in that window
first window choose
cell value is
second window choose
"greather than"
in the thrid window type
2
now click "format"
in the resulting window
choose "pattrens) last item
choose any color
click ok
click ok
if more than one row of data is there(both in column B and column K) just copy C1 down. remember c2 will be 260/K2 or (B2*260)/K2. I hope this is what you want
I am rephrasing it
suppose your cell is C1
if B1=0 then c1is 260/k1
if b1 is not 0 then c1 is (B1*260)/k1
if C1 is greater than 2 then c1 is colored red.
if this is so there is no easy formula (unless you want a macro).
but you can do one trick
in C1 copy paste this formula
=(IF(B1=0,260/K1,B1*260)/K1)
now conditionally format C1
select C1 click format(menu) conditonal format
in that window
first window choose
cell value is
second window choose
"greather than"
in the thrid window type
2
now click "format"
in the resulting window
choose "pattrens) last item
choose any color
click ok
click ok
if more than one row of data is there(both in column B and column K) just copy C1 down. remember c2 will be 260/K2 or (B2*260)/K2. I hope this is what you want