• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 433
  • Last Modified:

Format rows based on hidden rows values

Hello All,

I have a formatting question that needs to happen in a worksheet……There is a hidden calculated row. Conditional Format: if this row has a non-zero numeric value, then the cells below it are bolded

For example: if hiddenSumRow = 0 for myCol1, then numberforNextMonth for myCol1 is regular font and Unbolded.

For example: if hiddenSumRow <> 0 for myCol2, then numberforNextMonth for myCol2 is a bold  font

Thank you
  • 2
1 Solution
RayneAuthor Commented:
FYI - the hiddensumrow will be on a row thats hidden, not visible
On C7 select

Conditional formatting, select New Rule, then select Formula Is, in the formula box, enter


Then set the format as bold

Then copy format of cell C7 and paste over D7 to G7
RayneAuthor Commented:
Thank you Shannan :)

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

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