Conditional Format Formula

  • Thread starter Thread starter Ken Roberts
  • Start date Start date
K

Ken Roberts

I want to create a conditional format to change a cell
font and fill color when that cell's value, plus the sum
of 2 other cells, is evenly divisible by 10. Can anyone
assist me with the correct formula? Thanks.

Ken
 
I want to create a conditional format to change a cell
font and fill color when that cell's value, plus the sum
of 2 other cells, is evenly divisible by 10. Can anyone
assist me with the correct formula? Thanks.
Click to expand...

Use e.g. =MOD(SUM(A1:C1),10)=0

Rgds,
Andy
 
I want to create a conditional format to change a cell
font and fill color when that cell's value, plus the sum
of 2 other cells, is evenly divisible by 10. Can anyone
assist me with the correct formula? Thanks.

Ken
Click to expand...


=ROUND(A1/TIME(0,1,0),0)*TIME(0,1,0)

and format as [m] or multiply the result by 1440


--ron
 
Andy, thanks. That helped, but I discovered I have some
other things to figure out first.
Ron, yours was confusing and I really didn't follow it.
Thanks anyway.
-----Original Message-----
I want to create a conditional format to change a cell
font and fill color when that cell's value, plus the sum
of 2 other cells, is evenly divisible by 10. Can anyone
assist me with the correct formula? Thanks.

Ken
Click to expand...


=ROUND(A1/TIME(0,1,0),0)*TIME(0,1,0)

and format as [m] or multiply the result by 1440


--ron
.
Click to expand...
 
Andy, thanks. That helped, but I discovered I have some
other things to figure out first.
Ron, yours was confusing and I really didn't follow it.
Thanks anyway.
Click to expand...

The reason mine was confusing is that it had nothing to do with your question
:-(. I was responding to someone else and somehow got threaded here.

Oh well <sigh>.


--ron
 
Back
Top