![]() |
Turn all #N/A values white in a range
Hi
Excel 2003 I want to conditonal format a range, say C6 to H59, so that the font turns to white if the result in the cell is #N/A. The result comes from an IF Function. I need the N/A values to prevent them appearing in a graph as 0 values and so can't be deleted. Any help, much appreciated! Cheers |
All times are GMT +1. The time now is 02:08 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com