Font color with switch measure

[Anonymous]

Hey guys, I've got the following table that I got using Switch function. Now basically I want to do condition formatting for the last two rows(percentages) but only for them, that if they are above 0% then green otherwise red. The problem is, that I can only put formatting on two measures, which is the two colums that I got right now. So if I use it, the whole column goes green, but I only need to the last two rows. 
this is my switch function : 

[PaulDBrown · Accepted solution]

@Anonymous 

Try the following.

Create a conditional formatting measure along the lines of:

Conditional Format Values = 
IF(SELECTEDVALUE('Table'[Type]) IN {“2020 FAKTAS”, “2019 FAKTAS”, “2020 PLANAS”}, "black",
IF(AND(SELECTEDVALUE('Table'[Type]) IN {“POKYTIS NUO 2020 PLANO”}, [Pokytis nuo 2020 plano per mèn] >0), "Green",
IF(AND(SELECTEDVALUE('Table'[Type]) IN {“POKYTIS NUO 2019 FAKTO”}, [Pokytis nuo 2019 fakto per mèn] >0), "Green", "Red")))

The use this measure in the formatting pane under "Conditional Formatting", select the field and select the font colour option and use the [Conditional Format Values] measure (the yellow highlight should be the measure you are using in the visual):

[Anonymous]

@PaulDBrown  dude, you're lifesaver, thank you so much !!

[VijayP]

@Anonymous 

For conditional formatting you have to use separate switch function

Switch(true(),condition1,"Red",Condition2,"RGB(0,255,0)","Light Blue") and use the Field value option to take that on the field using conditional formatting! Hope this clarifies!

[Anonymous]

@VijayP After putting it into the conditional formatting, it still colours the whole column: 

[VijayP]

@Anonymous  Share the formula you have used for conditional formatting

[Anonymous]

@VijayP  

conditional formatting = SWITCH(TRUE(), [Pokytis nuo 2019 fakto per mėn] < 0,"Red", [Pokytis nuo 2019 fakto per mėn] > 0,"RGB(0,255,0)","Light Blue")