Conditional formatting with function IF

Question

Hello,&nbsp;I would need to make a yellow color in&nbsp; column N, if there is any value(diff from zero) in columns H:L.&nbsp;I used conditional formating as you can see below on screen, but it doesnt work. I dont understand why.&nbsp;I know I can write the same formula into the cell in column N, but I need just mark and posibility to add some comment.&nbsp;&nbsp;

djclements · Answer

FrantisekCZ&nbsp;Remove the IF function... only OR is required in Conditional Formatting:&nbsp;=OR(H3&gt;0; I3&gt;0; J3&gt;0; K3&gt;0; L3&gt;0)&nbsp;This could also be simplified with:&nbsp;=OR(H3:L3&gt;0)

frantisekcz · Answer

djclements&nbsp;I tried both, but none of them does work, I dont understand why&nbsp;

djclements · Answer

FrantisekCZ&nbsp;If you enter that formula directly in cell N3, does it return TRUE?

djclements · Answer

FrantisekCZ&nbsp;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:&nbsp;=NEBO(H3&gt;0; I3&gt;0; J3&gt;0; K3&gt;0; L3&gt;0)&nbsp;-- OR --&nbsp;=NEBO(H3:L3&gt;0)&nbsp;

Forum Discussion

Conditional formatting with function IF

Share

Resources