Results 1 to 3 of 3

Thread: Conditional formating based on numbers and texts

  1. #1

    Conditional formating based on numbers and texts



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi Team,

    i have coloumn A with Different status like Open, closed, available etc. Coloumn B have numbers.

    i am looking for a formula in condition formating for coloumn B.

    If the cell value in coloumn B is 2 or more, the same cell should be highlighted in Green.
    If the cell value in coloumn B is 1, the same cell should be highlighted in Yellow.
    If the cell value in coloumn B is 0, the same cell should be highlighted in Amber.
    If the cell value in coloumn B is less than 0, the same cell should be highlighted in Red.

    If the cell value in coloumn A is "Available", cell in coloumn B should be highlighted in Amber.

    Please help

  2. #2
    Seems simple

    Amber: OR($A2="Available",$B2=0)
    Green: $B2>=2
    Yellow: $B2=1
    Red: $B2<0

  3. #3

Tags for this Thread

Posting Permissions

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