Lock and Grey Out Cells Based on Cell Value in Excel - Excel Tips and Tricks
Learn how to lock and gray out cell based on cell value in Excel.
Grey Out Locked Cells
1) Select B5:F16
2) Home ~ Style ~ Conditional Formatting
3) New Rule...
4) Use formula to determine which cells to format
5) =$G5="Yes"
6) Format
7) Font tab
8) Color = Grey
9) Fill tab
10) Color = Dark grey
11) OK
12) OK
Lock Cell Based on Cell Value
1) Select B5:F16
2) Data ~ Data Tools ~ Data Validation
3) Setting tabs
4) Custom
5) Formula set =$G5＜＞"Yes"
6) Remove "Ignore blank"
7) Error Alert tab
8) Error message set to "Cell is locked!!"
9) OK
#excel #tips #shorts #fyp
Видео Lock and Grey Out Cells Based on Cell Value in Excel - Excel Tips and Tricks канала Rabi Gurung
Grey Out Locked Cells
1) Select B5:F16
2) Home ~ Style ~ Conditional Formatting
3) New Rule...
4) Use formula to determine which cells to format
5) =$G5="Yes"
6) Format
7) Font tab
8) Color = Grey
9) Fill tab
10) Color = Dark grey
11) OK
12) OK
Lock Cell Based on Cell Value
1) Select B5:F16
2) Data ~ Data Tools ~ Data Validation
3) Setting tabs
4) Custom
5) Formula set =$G5＜＞"Yes"
6) Remove "Ignore blank"
7) Error Alert tab
8) Error message set to "Cell is locked!!"
9) OK
#excel #tips #shorts #fyp
Видео Lock and Grey Out Cells Based on Cell Value in Excel - Excel Tips and Tricks канала Rabi Gurung
How to lock cells in Excel using conditional formatting? How to Conditionally Lock Cells in Excel Based on Other Values Excel - Lock and Grey Out Cells Based on Cell Value Lock and Grey Out Cells Based on Cell Value Protect range dynamically Lock Conditional Formatting short excel short shorts Excel tips and tricks Microsoft Excel tutorials Excel 2016 Excel 2013 Excel 2019 Microsoft 365 Excel 365 excel tips excel short tips how to Excel tips and tricks
Комментарии отсутствуют
Информация о видео
10 января 2025 г. 19:00:00
00:02:30
Другие видео канала
