Forum Discussion

jordielane's avatar
jordielane
New Contributor III
2 years ago

Cube View Formatting

Does anyone know how to format the object lookup cell in the cubeview? We currently have formatting on the cube view as follows.    If(IsRowNumberEven = True) Then BackgroundColor = #FFFFFFFF...
Cube View
  • JackLacava's avatar
    JackLacava
    2 years ago
    BackgroundColor = #FFFFFFFF
if RowName <> '' then 

	If(IsRowNumberEven = True) then
	   BackgroundColor = #FFFFFFFF, 
	   ExcelBackgroundColor = #FFFFFFFF,
	Else
	   BackgroundColor = #FFCFF0FC, 
	   ExcelBackgroundColor = #FFCFF0FC,
	End If

	If (RowName contains 'NoZebra') or (IsColHeader = true) then
	   BackgroundColor = #FFFFFFFF, 
	   ExcelBackgroundColor = #FFFFFFFF, 
	end if

end if

     

JackLacava's avatar
JackLacava
Honored Contributor

I'm not sure I follow. The color of the object lookup cell is determined by the default header format:

 

jordielane's avatar
jordielane
New Contributor III
2 years ago

Yes, the conditional formatting I have above that determines the alternating row format is in the default header format. I want that cell to be white, like the other column headers, but when I use IsColHeader = True it doesnt affect that cell and leaves it blue. I'm trying to find a way to format that specific cell to override the the alternating color formatting like I did with the column headers. 

  • JackLacava's avatar
    JackLacava
    Honored Contributor
    2 years ago
    BackgroundColor = #FFFFFFFF
if RowName <> '' then 

	If(IsRowNumberEven = True) then
	   BackgroundColor = #FFFFFFFF, 
	   ExcelBackgroundColor = #FFFFFFFF,
	Else
	   BackgroundColor = #FFCFF0FC, 
	   ExcelBackgroundColor = #FFCFF0FC,
	End If

	If (RowName contains 'NoZebra') or (IsColHeader = true) then
	   BackgroundColor = #FFFFFFFF, 
	   ExcelBackgroundColor = #FFFFFFFF, 
	end if

end if

     

    • jordielane's avatar
      jordielane
      New Contributor III
      2 years ago

      That worked, thank you so much!