Results 1 to 10 of 10

Thread: vba conditional formatting and multiple ifs

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    vba conditional formatting and multiple ifs

    I'm working in Excel 2002. Is there a way with vba to format and entire row based on the contents of both columns C and D.

    If C = "A" and D = "E" then the row color would be 40, light orange and the text bold in black 1.
    If C = "A" and D = "P" then the row color would be 35, light green and the text bold in dark red 9.
    If C = "X" and D = "E" then the row color would be 39, purple with no text formatting.

    I plan on having more than 3 instances so Format>Conditional Formatting won't work.
    Last edited by OPI8; 11-10-2008 at 02:09 PM.

Posting Permissions

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