bubblystace
New Member
- Joined
- Dec 5, 2017
- Messages
- 8
Hi All,
I'm stuck on some CF and hope someone can help please
I want to CF to highlight non-blank cells if B4 is not N/A. I've tried using formula below but not sure why it isn't working.
=IF(AND($D4='ConditionRatings'!$A$1:$A$4),AND(COUNTBLANK($D1:$D5)>0))
E.g. If B4 is "1" then B1, B2, B3 and B5 need to be populated, if not they are to be shaded red.
<tbody>
</tbody>
I'm stuck on some CF and hope someone can help please
I want to CF to highlight non-blank cells if B4 is not N/A. I've tried using formula below but not sure why it isn't working.
=IF(AND($D4='ConditionRatings'!$A$1:$A$4),AND(COUNTBLANK($D1:$D5)>0))
E.g. If B4 is "1" then B1, B2, B3 and B5 need to be populated, if not they are to be shaded red.
COLUMN A | COLUMN B | |
1 | Measurement | 10LM |
2 | Material | Brick |
3 | Height | (red fill) |
4 | Condition Rating | 1 |
5 | Remaining Life | (red fill) |
<tbody>
</tbody>