Conditional Appearence Format

Hello All,

Format on Conditional
Rows (diff1,diff2) are basically differences that should show 0 if (r1-r2) or (r2-r3) equals 0
Now the tricky part is I need to have either a number or a 0 in the rows (curentR, currentS) as that gets added on to diff1 or diff2.
Is it possible to have zeros for row  - curentR and currentS, and yet Not show it  - zeros for them don’t appear in those rows  -
Again – curentR, currentS rows will either have a number or a zero in value. BUT these rows can’t have nulls in place of zeros,
( as they are added up to other complex formulas and throws #Value errors…)
conditionalF.xlsx
RayneAsked:
Who is Participating?
 
tdlewisCommented:
You can hide all zero values in a worksheet. See this article:
http://www.techrepublic.com/blog/msoffice/three-ways-to-hide-zero-values-in-an-excel-sheet/8268
0
 
RayneAuthor Commented:
Attached how it should look. Even if zeros don’t appear for currentR or currentS rows but they are actually present in those rows…some kind of conditional formatting I guess
lookLikeThis.png
0
 
joaoalmeidaCommented:
Try:

Do a conditional format and when those cells are 0

use the following custom number format

,,,_-@_-

Joao
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
RayneAuthor Commented:
Hello Joao ,

I did the following but its still showing 0

1) Conditional Formatting > New Rule
2) Created a new rule (see attached pic)
3) Its not doing it
0
 
RayneAuthor Commented:
0
 
RayneAuthor Commented:
Hello tdlewis :)
Your suggestion worked Thank you
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.