I have columns A-O and rows 1-486. I need the fill color to be a light blue on Odd numbered rows in all columns starting at row 3.
Is there a formula or a way to do this without selecting each individual row and adding the fill color.
Thank you for the help!
Last edited by jedcadle; 01-29-2013 at 09:39 PM.
How about...
Conditional Formatting
- Highlight applicable range >> $A$3:$O$486
- Home Tab >> Styles >> Conditional Formatting
- New Rule >> Use a formula to determine which cells to format
- Edit the Rule Description: Format values where this formula is true: =MOD(ROW(),2)=1
- Format… [Number, Font, Border, Fill]
- OK >> OK
Last edited by jeffreybrown; 01-29-2013 at 09:26 PM.
HTH
Regards, Jeff
If you click and hold on cell A3, then drag highlight everything you want this to work on,
then conditional formatting,new rule, use formula
enter this formula:
=ISODD(ROW())
format, fill, select light blue, ok,ok
it should do what you are asking
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
You can use conditional formatting to do this. Highlight all the cells from A3 to O486 then click on Conditional Formatting | New Rule | Use a Formula ..., then enter this formula in the box:
=MOD(ROW(A3),2)=1
then click on the Format button, select the Fill tab and choose your colour. Then OK your way out.
Hope this helps.
Pete
Thank you all for the quick responses.
Last edited by jedcadle; 01-29-2013 at 09:39 PM.
Thank you very much, this worked perfectly!!!!Originally Posted by jeffreybrown
You are very welcome. Glad it worked out for you and thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks