Forum Discussion

EberleinHE's avatar
EberleinHE
Copper Contributor
Nov 18, 2021
Solved

Conditional formatting problem

Hi,   i have a problem and maybe someone can help me here.. I did a conditional formatting for my worksheets, the rule is =AND($E3<200000;$E3>0,39) for a fat and underlined format. Now in $E3 is a...
excel
Formulas and Functions
Macros and VBA
  • SergeiBaklan's avatar
    SergeiBaklan
    Nov 18, 2021

    EberleinHE 

    You have text in column E (">5"), not number.  In Excel any text is "more" than any number, thus formula in conditional formatting rule returns FALSE for any text.

     

    As variant you may change on formula like this

    or expand it replacing "<" if any as well

EberleinHE's avatar
EberleinHE
Copper Contributor
Nov 18, 2021
@Sergej Baklan, thanks for the response. The "> 5,00" should be fat and underlined..
Its not formatted- like you see in the screenshot. Any ideas?
  • EberleinHE's avatar
    EberleinHE
    Copper Contributor
    Nov 18, 2021

    SergeiBaklanHi Sergei,

     

    thank you for your seloution. It still dont work in my case. Please take a look to my conditional formatting:

     

     

    And here the rule for the row:

     

     

    Maybe its something with the rule in the row? I dont really know, i have no idea why it dont work..

     

    Thank you in advance!

     

    • SergeiBaklan's avatar
      SergeiBaklan
      Diamond Contributor
      Nov 18, 2021

      EberleinHE 

      You have text in column E (">5"), not number.  In Excel any text is "more" than any number, thus formula in conditional formatting rule returns FALSE for any text.

       

      As variant you may change on formula like this

      or expand it replacing "<" if any as well