SaraWitch
Active Member
- Joined
- Sep 29, 2015
- Messages
- 322
- Office Version
- 365
- Platform
- Windows
Hello peeps, and a happy new year to everyone!
I have a formula that returns "R", "A", or "G" depending on values in other cells, and that cell is conditionally formatted to change to appropriate colour (red, amber or green). My issue is that the formula is returning "R" no matter the values elsewhere. I have tried rearranging the formula (cells B10 to B13) but this isn't working either. There are 11 cells for the 'subsidy loss' and the formula needs to return appropriate letter for the latest entry in these cells (EP, EY, FH, FQ, FZ, GI, GR, HA JH, HS, AND IB) as well as the other criteria (cells D, ED (housing benefit), and IN (debt)) as per the note in Cell B5.
I have also replicated the formula in Sheet 1, which is working - to a point.
Here is a link to the workbook because it's too large and complicated to copy just the cells in question: EA Placements Manager
Any help would be greatly appreciated (especially as I've been at this since before Christmas!
) ![Smiling face with smiling eyes :blush: 😊](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f60a.png)
I have a formula that returns "R", "A", or "G" depending on values in other cells, and that cell is conditionally formatted to change to appropriate colour (red, amber or green). My issue is that the formula is returning "R" no matter the values elsewhere. I have tried rearranging the formula (cells B10 to B13) but this isn't working either. There are 11 cells for the 'subsidy loss' and the formula needs to return appropriate letter for the latest entry in these cells (EP, EY, FH, FQ, FZ, GI, GR, HA JH, HS, AND IB) as well as the other criteria (cells D, ED (housing benefit), and IN (debt)) as per the note in Cell B5.
I have also replicated the formula in Sheet 1, which is working - to a point.
Here is a link to the workbook because it's too large and complicated to copy just the cells in question: EA Placements Manager
Any help would be greatly appreciated (especially as I've been at this since before Christmas!
![Confounded face :confounded: 😖](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f616.png)
![Smiling face with smiling eyes :blush: 😊](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f60a.png)