Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???

[krunal123]

i was try "Change Font Color Black to White After Found " 0" Value In E Column , And may be I hope Hide row According Zero value. ???"

how to possible Conditional Formatting ????

 

[severynm]

First of all, holy tags!

Your conditional formatting is super simple. Start a new rule Conditional Formatting → Highlight Cells Rule → Equal To → type "0" with Custom Format, and then format as necessary. I colored the background so you can see the formatting is working.

To "hide" those cells, try using the built in filter functionality under the Data ribbon tab.