Unique excel formula

[Closed]
Report
-
Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
-
Hello,

I am using excel 2003. In my spreadsheet I have the following formula that I have to copy and paste into every single row in one column...

=(B1*260)/k1

--- second situation----
if B1 = 0 then I use the following: =(260/k1)

---third scenario------
If the value in the column is greater than 2.0 then I want to fill that cell with a specific color.

Is there any way to combine all of this into one formula to shave hours off my report every week?

1 reply

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
800
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

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!