Forum Discussion
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 pi...
See the attached version. I cleaned up some of the conditional formatting rules and formulas.
- 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";"")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;"")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-aDYDboDVzXTHANK YOU!!
