Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: CONDITIONAL FORMAT - green bar formula will not let other co

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    1,754
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I use formula =MOD(ROW()-9,1*2)+1<=1 as a conditional format in order to have rows of alternating color, but I can't get other conditions to work in the colored row??

    When I set up a condition where the word "OVDUE" will turn red and bold it only works in the rows that are not colored--in the green rows in does not change???

    [ This Message was edited by: em on 2002-04-11 13:37 ]

    [ This Message was edited by: em on 2003-01-31 23:36 ]

    [ This Message was edited by: em on 2003-02-01 00:01 ]

  2. #2
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I was playing with conditional formating and useing the following was able to make my green cells turn red.

    condition one

    cell value is equal to E2 (holding cell)

    format red

    With overdue in E2 when I type overdue into my formated cells they turn red

    condition two

    cell value is between 1 to 1000

    format green

    My cells are green with any number between 1 and 1000

    if I have a green cell and i type in overdue it now turns red.


    Hope this helped.........

    Denny

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-11 13:37, em wrote:
    I use formula =MOD(ROW()-9,1*2)+1<=1 as a conditional format in order to have rows of alternating color, but I can't get other conditions to work in the colored row??

    When I set up a condition where the word "OVDUE" will turn red and bold it only works in the rows that are not colored--in the green rows in does not change???

    [ This Message was edited by: em on 2002-04-11 13:37 ]
    See the Excel Help Index topic for "Conditional formats are not applied correctly.".

  4. #4
    Board Regular
    Join Date
    Feb 2002
    Location
    Florida
    Posts
    82
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Another thought..........

    If you want only the text in the cell to turn red..........

    format patterns to no fill, then text to red.

    Now we have green cells for numbers and the word overdue is red on a white background..


    Denny

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,184
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi im sure i have some code i developed that will hunt out some word ie RED and turn that to overdue... eh, other way arround and this is in one column so its a target address script, works well but go on me wick so i outed it, email me on JackintheUK and ill sent it to you but it will be tommorow or over the week end i am dreadful at remembering and i get a lot of emails i reply personally to everyone who takes the time to contact regardless, and all personal messages i also reply, just so you know bug me and ill do it promise.

    also in return please can i request you do not so much me but all reader PLEASE post my codes so everyone can use it, only fair, sure you understand,.,,

    thanks

    Chris D again bug me at work mate cheers your a good friend, you know ill forget otherwise.

    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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