SOLVED

Conditional formatting problem

%3CLINGO-SUB%20id%3D%22lingo-sub-2979228%22%20slang%3D%22de-DE%22%3EConditional%20formatting%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2979228%22%20slang%3D%22de-DE%22%3E%3CP%3EHi%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20a%20problem%20and%20maybe%20someone%20can%20help%20me%20here..%3C%2FP%3E%3CP%3EI%20did%20a%20conditional%20formatting%20for%20my%20worksheets%2C%20the%20rule%20is%20%3DAND(%24E%203%26lt%3B200000%3B%24E3%26gt%3B0%2C39)%20for%20a%20fat%20and%20underlined%20format.%3C%2FP%3E%3C%2FLINGO-BODY%3E%20Now%20in%20%24E%203%20is%20a%20rule%3A%20%3DIF(D3%3D%22-%22%3B%22%20-%22%3BIF(D3*6%2C85%26gt%3B5%2C%22%20%26gt%3B%205.00%22%3B%20ROUND(D3*6%2C85%3B2)))%20and%20if%20the%20value%20is%20over%200%2C73%2C%20it%20shows%20%22%26gt%3B%205%2C00%22%20like%20the%20rule%20was%20set.%20The%20problem%20is%2C%20that%20this%20isnt%20fat%20and%20underlined%20like%20set%20in%20the%20first%20rule%20with%20the%20Cconditional%20formatting..%20Can%20anyone%20help%20me%20here%3F%3CP%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22EberleinHE_0-1637223340205.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F327898iCE14E60FB021566B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22EberleinHE_0-1637223340205.png%22%20alt%3D%22EberleinHE_0-1637223340205.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThe%20%22%26gt%3B%205%2C00%22%20should%20be%20fat%20and%20underlined..%3C%2FP%3E%3CP%3EThanks%20in%20advance.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2979228%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2979289%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2979289%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1222410%22%20target%3D%22_blank%22%3E%40EberleinHE%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EAnd%20what%20is%20the%20problem%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2979310%22%20slang%3D%22de-DE%22%3ERe%3A%20Conditional%20formatting%20problem%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2979310%22%20slang%3D%22de-DE%22%3E%40Sergej%20Baklan%2C%20thanks%20for%20the%20response.%20The%20%22%26gt%3B%205%2C00%22%20should%20be%20fat%20and%20underlined..%3CBR%20%2F%3EIts%20not%20formatted-%20like%20you%20see%20in%20the%20screenshot.%20Any%20ideas%3F%3C%2FLINGO-BODY%3E
Occasional Contributor

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 rule: =IF(D3="-";"-";IF(D3*6,85>5;"> 5,00";ROUND(D3*6,85;2))) and if the value is over 0,73, it shows "> 5,00" like the rule was set. The problem is, that this isnt fat and underlined like set in the first rule with the Cconditional formatting.. Can anyone help me here?

 

EberleinHE_0-1637223340205.png

The "> 5,00" should be fat and underlined..

Thanks in advance.

 

7 Replies

@EberleinHE 

And what is the problem?

@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 

It works in my case

image.png

If you open attached file formulae will be in your locale format.

@Sergei BaklanHi Sergei,

 

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

 

EberleinHE_0-1637236127298.png

 

And here the rule for the row:

 

EberleinHE_1-1637236248992.png

 

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!

 

best response confirmed by EberleinHE (Occasional Contributor)
Solution

@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

image.png

or expand it replacing "<" if any as well

@Sergei Baklan worked! Thanks a lot!

@EberleinHE , you are welcome, glad to help