Hi
for the conditional formating issue.
- select the cells for which an NA error can occur
- goto the conditional format dialo
- enter the following formula
=ISNA(cell_reference)
where cell_reference ist the first cell of your selection.
e.g.
=ISNA(A1)
- now choose a white font for these condition
--
Regards
Frank Kabel
Frankfurt, Germany
Ant_Emberson wrote:
I read this topic with glea! It was just what I was looking for... So
many thanks for that
This is my formula
=IF(SUM('Enter Data'!O5/1.175)*('Enter
Data'!P5/100)=0,NA(),SUM('Enter Data'!O5/1.175)*('Enter
Data'!P5/100))
forcing the formula to give #N/A where there is no value in the
original data, you mentioned using the conditional formatting to
"Hide" the #n/a, no matter what I try the 'N/A will not go white.
Can you help?
Thanks