Conditional formatting 1

[xxentric]

Is it possible to use conditional formatting to to turn a cell red whenever the value in the cell is divisible by 10 ??

 

[SkipVought]

hi,

If the cell is A1...
[tt]
=MOD(A1,10)=0
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kwbMitel]

SkipVought,

This type of question has been plaguing me for quite some time. I found a round about answer by using the Conditional Formatting embedded in a Macro.

I can't see how the cammand above will turn the Cell Red. It would be nice to have formula driven conditional formatting but to date I haven't found a way.

*******************************************************
Occam's Razor - All things being equal, the simplest solution is the right one.

 

[SkipVought]

Format > Conditional Formatting...

Use Formula is:

Set your format.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[kwbMitel]

I was soooo close.

Missed the pull down in conditional formatting.

Trees / Forest thing.

*******************************************************
Occam's Razor - All things being equal, the simplest solution is the right one.