|
Posted to microsoft.public.excel.misc
|
|
|
Highlighting alternate rows
Wonderful!! :) Thanks!
"Max" wrote:
In excel 03, select the range, then click Format Conditional Formatting
Under Condition 1, click the droplist, select "Formula Is:" option
Then paste the suggested formula into the box next to it
Click Format button, format to taste Ok out
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:300 Subscribers:70
xdemechanik
---
"NicoleS" wrote:
Thank you Max, but I don't understand how/where to enter the formula?
I tried to enter it on the formula bar, but nothing happened.
I looked up "conditional formatting" then found it under the formatting menu
& tried to fill that in, but there was no space for a formula.
|