Attachment has eight possible combinations of Col E and Col F.
Want conditional formatting to change colour of Col F cell red or green based on following:
If E="Very high" and F <98%, F format "Red"
IF E="High" and F<95, F format "Red"
If E="Significant" and F<85%, F format "Red"
If E="Low" and F<75%, F format "Red"
If E="Very high" and F >=98%, F format "Green"
IF F="High" and F>=95, F format "Green"
If E="Significant" and F >=85%, F format "Green"
If F="Low" & E >=75%, F format "Green"
Putting combined formula in COl N identifies each combination perfectly:
"=IF(OR(AND(E1="Very High",F1<98%),AND(E1="High",F1<95%),AND(E1="Significant",F1<85%),AND(E1="Low",F1<75%)),"Red",IF(OR(AND(E1="Very High",F1>=98%),AND(E1="High",F1>=95%),AND(E1="Significant",F1>=85%),AND(E1="Low",F1>=75%)),"Green"))"
But splitting the formula and setting each half to Conditionally Format Col F throw an error message that there is a missing parenthesis?
"OR(AND(E1="Very High",F1<98%),AND(E1="High",F1<95%),AND(E1="Significant",F1<85%),AND(E1="Low",F1<75%))"
"OR(AND(E1="Very High",F1>=98%),AND(E1="High",F1>=95%),AND(E1="Significant",F1>=85%),AND(E1="Low",F1>=75%)"
Problem is I can't see it?
Any suggestions, pointers or solutions accepted gratefully as ever
Ochimus
Bookmarks