Re: Conditional Format Formula

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Ken Roberts (anonymous_at_discussions.microsoft.com)
Date: 05/24/04 

Date: Mon, 24 May 2004 10:40:01 -0700

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-----
>On Mon, 24 May 2004 06:21:44 -0700, "Ken Roberts"
><anonymous@discussions.microsoft.com> wrote:
>
>>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
>
>
>=ROUND(A1/TIME(0,1,0),0)*TIME(0,1,0)
>
>and format as [m] or multiply the result by 1440
>
>
>--ron
>.
>

Quantcast