Forum Discussion
Conditional formatting with function IF
Hello, I would need to make a yellow color in column N, if there is any value(diff from zero) in columns H:L. I used conditional formating as you can see below on screen, but it doesnt work. I d...
FrantisekCZ Remove the IF function... only OR is required in Conditional Formatting:
=OR(H3>0; I3>0; J3>0; K3>0; L3>0)
This could also be simplified with:
=OR(H3:L3>0)
FrantisekCZ Based on the results of using Google Translate to detect the language shown in your screenshot, I'm guessing the OR function translates to the NEBO function in your system. Try this instead:
=NEBO(H3>0; I3>0; J3>0; K3>0; L3>0)-- OR --
=NEBO(H3:L3>0)FrantisekCZ If you enter that formula directly in cell N3, does it return TRUE?