MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Conditional Formatting


Posted by Ed Jakus on September 26, 2001 12:10 PM

I would like to use a conditional format to highlight even numbered rows in a sheet. I've tried using

=isodd(row()) and a million other variations, but can't get it to work.

Any suggestions?

P.S. I know I have no skills when it comes to functions in Excel, so please be kind...


Posted by IML on September 26, 2001 12:14 PM

You could use formula =
=MOD(ROW(),2)=0

Good luck

Posted by Aladin Akyurek on September 26, 2001 12:16 PM

Ed,

Select the range of interest, activate Format|Conditional Formatting, choose "Formula Is" for Condition 1, and enter

=MOD(A1,2)=0

I assumed your range to start in A1. Change this to the start cell of your range. Use no $-signs around the cell address.

Activate Format and choose the formatting you want.

Click OK.

Aladin

==========

Posted by Aladin Akyurek on September 26, 2001 12:18 PM

I took the cell values, not rows. So look at IML's propsal. :)

Posted by Ed Jakus on September 26, 2001 12:18 PM

Acutally I mispoke....I said even number rows...I should have said odd. I agree, =MOD(ROW(),2)=0 does work, but how do I check for the opposite to get the odd number rows instead? Or, how do you test to see if the function is false?

Posted by Aladin Akyurek on September 26, 2001 12:26 PM

IML is apparently

off-line. That would be:

=MOD(ROW(),2)<>0<p>================

Posted by Ed Jakus on September 26, 2001 12:29 PM

Re: IML is apparently

That solved the problem! Thanks for your efforts!

Posted by Ed Jakus on September 26, 2001 12:31 PM

Thanks for trying...appreciate all the help.