fish asked in Computers & InternetSoftware · 1 month ago

Conditional formatting in excel?

Cell B2 = 9114

Cell B3 = 9114.251

How can i format it (conditional) to only look at the 9114. I want Cell B3 to highlight once it matches Cell B2 regardless what follows the decimal.

Thx.

6 Answers

Relevance
  • 4 weeks ago

    It's not possible to apply conditional formatting between two cells having different values due to decimal.

  • 4 weeks ago

    Ok,no excel is a lie a,insert your category in graph,and watch it among the chart!You must not fight with degrees and you can,t get always what you need.

  • Lv 7
    4 weeks ago

    use the "CELL CONTAINS" option

  • 1 month ago

    The suggested RND function will round UP when you may not want it to round up. Example when B3 = 9114.689, it will round up to 9115 and will not match..

    Additionally using the formula one poster suggested with the >= (greater than or equal to)  will not work if the number in B3 doesn't match before the decimal. If B3=9112.256 and B2-9111, you get a false highlight. 

    Instead, in your conditional formatting, use this formula

    =INT($B$3)=$B$2

    tested and works great. 

  • What do you think of the answers? You can sign in to give your opinion on the answer.
  • Use  the rounddown function so regardless of the decimal the number before it won't change. 

  • Anonymous
    1 month ago

    Use a formula as the condition. 

    =B3 >= B2

Still have questions? Get answers by asking now.