Hey all,
I've got one which has really started to beat me. I'm trying to set up a conditional formatting, but the requirement is based off a few factors. The run-down:
- The spreadsheet is to monitor the amount of times a piece of equipment has broken, and subsequently been "changed out" (to fix it).
- If an "Equipment number" (column A) and "Date of RBB break" (column E) are entered, it is considered a break (i.e. there can be situations where equipment # is entered, but no break date, meaning the entry is NOT a break)
- Column I ("Date of RBB changeout") needs to turn RED IF >=2 breaks have occurred WITHOUT a changeout
I'm doing my head in on this one and really want it finished because it's for work! Can someone smarter than me please help!
I've got one which has really started to beat me. I'm trying to set up a conditional formatting, but the requirement is based off a few factors. The run-down:
- The spreadsheet is to monitor the amount of times a piece of equipment has broken, and subsequently been "changed out" (to fix it).
- If an "Equipment number" (column A) and "Date of RBB break" (column E) are entered, it is considered a break (i.e. there can be situations where equipment # is entered, but no break date, meaning the entry is NOT a break)
- Column I ("Date of RBB changeout") needs to turn RED IF >=2 breaks have occurred WITHOUT a changeout
I'm doing my head in on this one and really want it finished because it's for work! Can someone smarter than me please help!