Hiding Error (Using Condition Formatting) Thanks Fluff13

**Mahmoudelnemr** · 06-24-2019, 09:44 AM

I want To hide error values "#N/A" using condition formatting for the range ($G$6:$O$53)
to color the error font with white, but still the errors appear
i used the formula ="IFERROR($G$6)" applied to =$G$6:$O$53
i would appreciate ur help (sheet attached)

**Fluff13** · 06-24-2019, 09:52 AM

Use

Formula:

Please Login or Register  to view this content.

**Mahmoudelnemr** · 06-24-2019, 09:55 AM

Originally Posted by Fluff13

Use

Formula:

Please Login or Register  to view this content.

Unfortunately, same result no result

**Fluff13** · 06-24-2019, 09:57 AM

It works for me on your file, did you copy the formula exactly as supplied, or did you change it?

**Mahmoudelnemr** · 06-24-2019, 10:00 AM

Originally Posted by Fluff13

It works for me on your file, did you copy the formula exactly as supplied, or did you change it?

It worked now :D
Thanks alot

**Fluff13** · 06-24-2019, 10:18 AM

You're welcome & thanks for the feedback

Hiding Error (Using Condition Formatting) Thanks Fluff13

LinkBack

Thread Tools

Rate This Thread

Display

Hiding Error (Using Condition Formatting) Thanks Fluff13

Re: Hiding Error (Using Condition Formatting)

Re: Hiding Error (Using Condition Formatting)

Re: Hiding Error (Using Condition Formatting)

Re: Hiding Error (Using Condition Formatting)

Re: Hiding Error (Using Condition Formatting) Thanks Fluff13

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Conditional Formatting & Error hiding

Hiding Excel rows on condition without using macro

Hiding sepecific column on based of condition

Hiding a row based on condition

[SOLVED] Hiding rows on condition

Hiding Column based on If Condition

[SOLVED] Hiding cells on condition

Bookmarks

Bookmarks

Posting Permissions