SOLVED

# need help with further processing of conditional formatting

Copper Contributor

# need help with further processing of conditional formatting

Hi all,

I have tried to create an automatic date calculation for HR termination processes and worked with conditional formatting. Now I try to take the one information which is orange into the pink field below. Is that possible? Dependent of the information above (yellow) the orange line will change.

Furthermore, I have some IF-calculations in my sheet. Sometimes the 30 in field B22 appears, sometimes a 90 in field B23 or a 180 in field B24. This works fantastic. But then I want to summarize the numbers I receive, but there is always a 0.00 as a result.

Do you have any solution ideas for me? Below you find a screenshot of my sheet.

Let me know, if I have to clarify something in more detail :)

Thanks a lot for your help!!!

BR, Selina

6 Replies

# Re: need help with further processing of conditional formatting

What is the conditional formatting rule?

What is the formula in B22:B24?

# Re: need help with further processing of conditional formatting

Hi Hans, thanks for your reply!

The conditional formatting rules are different. There is a connection to the contents of B4 and B6 (or C6). This rules are deciding which line should be orange. (screenshot below).
Example:
rule: =AND(\$B\$6=8;\$B\$4="Produktion")
is applied to: =\$A\$14:\$J\$14

The formulas in B22:B24 are:
B22: =IF(B6<2;"30";"")
B23: =IF(AND(B6>1.99;B6<6);"90";"")
B24: =IF(B6>5;"180";"")

# Re: need help with further processing of conditional formatting

Thanks.

1) I'd need to know all the rules. Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

2) Your formulas return text values instead of numbers. Change them to:

B22: =IF(B6<2;30;"")
B23: =IF(AND(B6>=2;B6<6);90;"")
B24: =IF(B6>=6;180;"")

# Re: need help with further processing of conditional formatting

Hi Hans,

there is absolutely no sensitive data, as it is just a template without any realistic data.
I have uploaded the file here:
https://we.tl/t-aDYDboDVzX

THANK YOU!!

best response confirmed by Selbelle (Copper Contributor)
Solution

# Re: need help with further processing of conditional formatting

See the attached version. I cleaned up some of the conditional formatting rules and formulas.

# Re: need help with further processing of conditional formatting

oh my god, thank you!!! that's so fantastic! you are my hero of the day!

THANK YOU SO MUCH!!!

1 best response

Accepted Solutions
best response confirmed by Selbelle (Copper Contributor)
Solution

# Re: need help with further processing of conditional formatting

See the attached version. I cleaned up some of the conditional formatting rules and formulas.