Results 1 to 4 of 4

how do i replicate formating rules that i have made?

Threaded View

  1. #1
    Registered User
    Join Date
    04-22-2009
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    4

    how do i replicate formating rules that i have made?

    basicaly i have created a rule in one cell to reflect a certain outcome of other cells and i need to recreate this rules about 30 or so times with the next lines of information.

    my question is, is their a easy way to replicated this formula to pertain to the next set of information or do i have to go through the long process of recreating the rule for each set of information?


    edit: so i added the attacted spreadsheat. u can look at the rules to see what its suppose to do. the cells that are green in color have 2 formulas in them. one to make it turn red if its false and another to turn green if its true.

    i need to do this for the entire 4 times in each row for about 31 rows
    Attached Files Attached Files
    Last edited by kirvo85; 06-09-2009 at 02:20 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1