filmov
tv
Conditional format and lock cells with VBA
Показать описание
Change the colour and lock cells of a certain value. How to determine the interior colour of a cell. Lock cells over a certain colour. Colour cells over a certain value. Conditional format and lock cells with VBA
Code
Sub showcolour()
MsgBox cellcolour
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim x As Double
Dim rng As Range
Dim colorIndex As Integer
colorIndex = 3
x = 2
With Sheets("sheet1")
.Unprotect "test"
.Cells.Locked = False
End With
For x = 2 To 200
Dim color As Long
If Cells(x, 1).Value is greater than 5 Then
Cells(x, 1).Select
Selection.Locked = True
End If
Next x
Sheets("Sheet1").Protect "test"
End Sub
Contact me regarding customizing this template for your needs.
Excel one-on-one on-line training available. Email me to arrange.
I am able to provide online help on your computer at a reasonable rate.
Check out my next one-hour Excel Webinar
I use a Blue condensor Microphone to record my videos, here is the link
Check out Crowdcast for creating your webinars
If you need to buy Office 2019 follow
I use Tube Buddy to help promote my videos
Check them out
Follow me on Facebook
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I've used or have experience with.
Code
Sub showcolour()
MsgBox cellcolour
End Sub
Private Sub Worksheet_Change(ByVal Target As Range)
Dim x As Double
Dim rng As Range
Dim colorIndex As Integer
colorIndex = 3
x = 2
With Sheets("sheet1")
.Unprotect "test"
.Cells.Locked = False
End With
For x = 2 To 200
Dim color As Long
If Cells(x, 1).Value is greater than 5 Then
Cells(x, 1).Select
Selection.Locked = True
End If
Next x
Sheets("Sheet1").Protect "test"
End Sub
Contact me regarding customizing this template for your needs.
Excel one-on-one on-line training available. Email me to arrange.
I am able to provide online help on your computer at a reasonable rate.
Check out my next one-hour Excel Webinar
I use a Blue condensor Microphone to record my videos, here is the link
Check out Crowdcast for creating your webinars
If you need to buy Office 2019 follow
I use Tube Buddy to help promote my videos
Check them out
Follow me on Facebook
Follow me on twitter
easyexcelanswers
IG @barbhendersonconsulting
You can help and generate a translation to you own language
*this description may contain affiliate links. When you click them, I may receive a small commission at no extra cost to you. I only recommend products and services that I've used or have experience with.
0:05:17
Lock Cells & Protect Excel Worksheet - EVEN by Cell Color!
0:02:01
Highlight Locked or Unlocked Cells in Excel using Conditional Formatting
0:03:21
Conditional format and lock cells with VBA
0:06:01
How to Lock Cells 🔒in Excel to Protect your Formulas & Only Allow Input where Needed
0:06:21
Excel - Conditionally Lock Cells Based on Other Values
0:00:29
Conditional Formatting in Excel | Highlight Marks Pass/Fail #shorts #excel
0:14:03
3- TYPES OF LOCK FUNCTION WITH CONDITIONAL FORMATTING
0:03:48
Conditional formatting and protecting worksheet
0:09:29
Excel How To: Format Cells Based on Another Cell Value with Conditional Formatting
0:03:10
How to Protect Conditional Formatting Rules in Excel
0:06:43
Conditional Formatting in Excel Tutorial
0:01:30
Excel Conditional Formatting based on Another Cell | Highlight Cells
0:05:17
LOCK or UNLOCK Cells Based on CELL COLOUR or Other Format
0:00:27
How to: Use Conditional Formatting Rules in Sheets
0:12:00
5 Conditional Formatting tips to make you a rock star at work 🤘
0:03:23
Excel - Use Conditional Formatting on a Cell Based on Another Cell's Value
0:03:34
Conditional Formatting Based on Another Cells Values – Google Sheets
0:06:54
Excel Essentials -- Level UP! -- Conditional Formatting for Due Dates and Expiration Dates
0:02:01
Excel Lock Cells and Protect Formula (but allow data entry)
0:05:39
Excel Conditional Format Based on Another Cell | Highlight Entire Row with Conditional Formatting
0:00:26
Conditional Formatting on Mobile Google Sheets #shorts
0:00:33
Google Sheets Conditional Format Checkbox #shorts
0:30:58
8 Expert Tricks for Conditional Formatting in Excel
0:00:56
Google Sheets Checkbox - Apply Conditional Formatting across entire row
Комментарии