PC Review

Thread Tools Rate Thread

Re: Conditional Formatting in 2007

Per Jessen
Posts: n/a
      16th May 2010
You do not need your formula in A1 and down.

Just select A1:A100, goto Format > Conditional Formatting > Formula
is: '=Mod(Row(),2)=0'

Select formatting as desired.


On 17 Maj, 00:09, "Live Long & Prosper" <(E-Mail Removed)> wrote:
> Playing with Excel I'm trying to conditionally format cells that divided
> evenly in a range, heres a simple example
> In cell A1 I put '=50000000/row()' I then extend (drag) that for 100 rows.
> What I'd like to do is then select A1:A100 and conditionally format so the
> ones that divded with no remainder are highlighted.
> I can't figure out how to format a whole range with a formula.

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Conditional Formatting No Longer Conditional in 2007 Beta =?Utf-8?B?Q2FjdHVhci1Oby1KdXRzdQ==?= Microsoft Excel Crashes 0 17th Nov 2006 11:01 PM
Conditional Formatting - Can I select a select with Conditional Formatting? Greegan Microsoft Excel Worksheet Functions 5 31st Oct 2005 03:19 PM
Conditional Formatting that will display conditional data =?Utf-8?B?QnJhaW5GYXJ0?= Microsoft Excel Worksheet Functions 1 13th Sep 2005 05:45 PM
Conditional Formatting w/ Conditional Functions... using AND =?Utf-8?B?S1dHU05B?= Microsoft Excel Programming 2 16th Mar 2004 07:56 PM
Conditional, Conditional Formatting John Meyer Microsoft Excel Discussion 8 21st Dec 2003 09:37 PM




All times are GMT +1. The time now is 06:02 PM.