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
