#conditionalformatting

Hello everyone, I have pretty straight forward question, but just can't get it to work. I want that conditional formatting is applied to the column range only, in Pivot table (and when the pivot table column range shrinks or expands due to changes in the main document that formating is only...

How can I change the row section´s color based on other cells´ colors? More precisely: IF (D6=green AND D7=green AND D8=green), D1 to D5 green

Greetings, I have a column with values and I change the fill using a set of conditional formatting rules with the criteria below (well as much as I can remember from work, so these are not the exact values but the same principle) =COUNTIF(A1:A100, "*AA*") =COUNTIF(A1:A100, "*AB*")...

Hi. I am having difficulties in finding ways to highlight cells with the same formula. For example: The cell highlighted in yellow has the =X + no. of days format. Whereas the image below has the =EDATE(x,x) formula. I need the cells with same formula to be highlighted in one color, same with...

How to Highlight RAW After Bold Text ??? "E2" cell text is bold after Highlight raw on red color with white font & bold also

I currently have a cell that the user inputs an numeric value into (highlighted in yellow). What I am trying to achieve is if the radio button selected is "YES" then user still can manually enter a value into the cell but if the radio button is "NO" then the same highlighted cell now returns a...

Need help to set the RAG format of the cell Conditions as follow: 0 = green, > 0 is yellow, > 0 for last 3 months = red Sample 1 Sample 2 Sample 3 Sample 4 Sample 5 Sample 6 Current Month 1 0 1 1 0 0 Month-1 0 1 1 1 0 0 Month-2 0 1 1 0 0 1 RAG Amber Green Red Amber Green Green...