RAG Status with Conditional Formatting in Excel 

Need help learning Excel? You need to check this out: bit.ly/3xZ63LC

Thank you, just used this for work. very helpful and to the point!

Thank you so much! I never realised how easy it was!

Excellent video thank you

Thank thank thank you ❤

THANK YOU SO MUCH

Thank you so much for this,

Very helpful 🙂👍🏻

Hello, In a pivot table (having collapsed rows), for a particular column (showing percentage values) I have applied traffic lights which are available in conditional formatting. Here slicers are also created by selecting pivot cells/data. Now when we are selecting an/any option from slicers, the traffic lights are showing incorrect colors for respective percentage values. We have tried multiple ways to fix it but yet they all fail. Please help if somebody knows on the same. Thanks, Hitesh.

Thank you so much for the video! Could you change a whole row color based on a specific status ? I've created a job applications sheet and I would like to color the whole row according to specific status (rejected, interview, other).

Thanks guys, now subscribed also.

Hello can we do this in pivot table Nd incase we need with just the flags .how to do that

Could also add rules to make text change to the same colour then the names of the colours would not be visible :)

Would like a video on explanation of vlook up

HI I have a list of fleet reg no's. i would like to have a drop down box so i can change it from yellow if done or red if it is defected. can this be done and how. as i am not great with formulas.

RAG status based on nothing? for those making data driven decisions, this won't work