This is How it's supposed to look in the end. I have no problem with columns T to Z changing colour based on their values, but I can't figure out how to change AB...
I'm trying to make the checkmark and X symbols change automatic; if all cells in a row (T-Z) are green, a checkmark should be in AB. If any cell in a row (T-Z) is red, an X should be in AB
I've tried conditional formatting, an IF function and OR functions but they either don't work or give me error messages.
my last try was this one:
I'd appreciate any help or tips on the subject. Thank you!
I'm trying to make the checkmark and X symbols change automatic; if all cells in a row (T-Z) are green, a checkmark should be in AB. If any cell in a row (T-Z) is red, an X should be in AB
I've tried conditional formatting, an IF function and OR functions but they either don't work or give me error messages.
my last try was this one:
Excel Formula:
=OR(B4>=4, C4>10,D4>3, E4>1400, F4>1, G4>1, H4>2500)I'd appreciate any help or tips on the subject. Thank you!
