21 04 06.xlsm | |||
---|---|---|---|
A | |||
1 | |||
2 | |||
3 | |||
4 | |||
5 | #N/A | ||
Sheet2 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A5 | A5 | =IF(A30="",NA(),INDEX($Y$7:$AB$33,$I30,3)) |
Cells with Conditional Formatting | ||||
---|---|---|---|---|
Cell | Condition | Cell Format | Stop If True | |
A5 | Expression | =ISNA(A5) | text | NO |
Select the cellPeter - Not able to apply conditional Formatting, please share steps.