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
2 years ago

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!