Forum Discussion
FrantisekCZ
Dec 05, 2023Copper Contributor
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
Dec 05, 2023Copper Contributor
djclements
Dec 05, 2023Silver Contributor
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)