How to use Relative and Absolute Cell References in Conditional Formatting in Excel - Office 365

Excel formulas can use 4 types of cell references
1. Absolute Cell References
2. Relative Cell References
3. Mixed Cell References
4. Absolute Column and Relative Row References
In conditional formatting mixed cell references are used more frequently. This video explains the different types of cell references and they are used in conditional formatting.
To download practice Excel file please click on the link below
www.findeasyso...
To learn more about conditional formatting of cells in Excel please click on the link below
• Conditional Formatting...

[@nitinshri]

didnt use this logic but got Idea for what action I wanted to perform on my cells. Thanks!

[@FindEasySolution]

You are welcome. Please subscribe to our channel.