[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 491
  • Last Modified:

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
0
Rayne
Asked:
Rayne
  • 4
1 Solution
 
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
 
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
NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

 
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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now