# 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
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 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
your problem is not completely clear
I am rephrasing it
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