conditional format vba

  1. A

    Method to highlight names with consecutive attendance

    I am using Excel 2007 and asking your help for the best (and the easiest) way to highlight the names of people who have 6-month of consecutive attendance every Sundays. My worksheet's layout are as follow: Column A: Last Name Column B: First Name Row 9: Dates (with "S9" as Jan...
    • AlexCHI
    • Thread
    • attendance column conditional format vba excel 2007 sunday
    • Replies: 16
    • Forum: Excel Questions
  2. S

    Apply "hard" conditional formatting using VBA

    I want to apply 'conditional' formatting to a worksheet, but I'm not sure how to get started. I would rather 'hard' format the cells, than actually use the conditional formatting. Here's the basics of what I want to achieve: 1. If 'This week'!J2 <> 'Last week'!J2 - fill 'This week'!J2 with red...
  3. C

    Conditional Format Based on Cell Value - vba

    With the click of a toolbar button, I've got my vba inserting a new tab, renaming it, inserting headers and now working on the code to insert all the formulas needed in 12 columns to copy down as far as there is data. The 4th column D is the hardest. Currently, I'm using manual "Conditional...
  4. M

    condition format to check for differences

    For Each Cell In Range("New")</SPAN></SPAN> Cell.Select</SPAN></SPAN> Selection.FormatConditions.Add Type:=xlCellValue, Operator:=xlNotEqual, Formula1:="=RC[1]"</SPAN></SPAN> With Selection.Interior</SPAN></SPAN> .ColorIndex = 42</SPAN></SPAN> .Pattern =...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top