Hy, I have one problem, probably small problem for someone but big for me.
I do not understand, why is conditional formating not applying on cell in my document completely. There is color change every time on dropdown select, but Number format is not changing until i alterate some cell in document.
Also, i noticed, after some cell change it changes three times on my action, one time for each input, and color and format number on big cell, but after that not any more.
I need answer if is that normal and how i can accomplish to change automaticly after dropdown change if i can at all.
Greetings from Croatia, sample file in in attachment.
P.S. #1 I can not use macro because settings must be on High and i can not change that.
P.S. #2 Sorry for bad English![]()
Bookmarks