Results 1 to 2 of 2

Thread: flag in excel

  1. #1
    Join Date
    Jan 2011

    Unanswered: flag in excel

    Hi everyone,

    I have a task to create something in excel that would enable a change in a field of a column to reflect on another field in another column such that;

    If field1 is blank, then field 2 should be red. And if difference between field1 and field3 is equal or greater than 7 then field2 should turn red, else green.

    Please can someone HELP ME. am stuck. I don't mind if i could have the query or calculated expression for it. Thanks

  2. #2
    Join Date
    Sep 2008
    London, UK

    You can do this with conditional formatting. The exact instructions will depend on your version of Excel?

Posting Permissions

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