Conditional Content Macro, Is it possible To assign two different colors to conditional content?

Hello Everybody,

 

My question is that is it possible in confluence assign different highlight colors(normally it is gray) to different content.

For example 

content from 1st condition(have a light yellow highlight color) 

content from 2nd condition(have a light green highlight color) 

 

Many Thanks

adada.PNG

2 answers

This widget could not be displayed.

Is this what you are looking for
- if number of data rows in Table2 exceeds 25 then run the macro

Code:

Sub Scroll_Start()
If ActiveSheet.ListObjects("Table2").DataBodyRange.Rows.Count > 25 Then
    NextTime = Now + TimeValue("00:00:02") 'Two second interval
    ActiveWindow.Zoom = 125
    Application.DisplayFullScreen = True
    If ActiveWindow.VisibleRange.Rows(1).Row < 17 Then
        ActiveWindow.SmallScroll Down:=1
    Else
        ActiveWindow.ScrollRow = 1
    End If
    Application.OnTime NextTime, "Scroll_Start"
End If
End Sub

or maybe this so that zoom and full screen happens regardless
Code:

Sub Scroll_Start()
    NextTime = Now + TimeValue("00:00:02") 'Two second interval
    ActiveWindow.Zoom = 125
    Application.DisplayFullScreen = True
    If ActiveSheet.ListObjects("Table2").DataBodyRange.Rows.Count > 25 Then
        If ActiveWindow.VisibleRange.Rows(1).Row < 17 Then
            ActiveWindow.SmallScroll Down:=1
        Else
            ActiveWindow.ScrollRow = 1
        End If
    End If
    Application.OnTime NextTime, "Scroll_Start"
End Sub
This widget could not be displayed.

An Excel column contains a text value representing the category of that row. Is there a way to format all cells having a distinct value a unique color without manually creating a conditional format for each value? Example: if I had the categories bedroom, bedroom, bathroom, kitchen, living room, I would want all cells containing bedroom to be a particular color, bathroom a different color, etc.

AppValley Vidmate TweakBox

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Sep 17, 2018 in Confluence

Why start from scratch? Introducing four new templates for Confluence Cloud

Hi my Community friends!  For those who don't know me, I'm a product marketer on the Confluence Cloud team - nice to meet you! For those of you who do, you know that I've been all up in your Co...

601 views 8 6
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you