conditoinal formatting

  1. F

    Conditional format - don't highlight text

    Is it possible to have conditional formatting to exclude text, in this instance highlight values greater than 1.00 and don't highlight text values.
  2. S

    For next loop doesn't work with certain PivotFields

    When I use this code Sub FormatTest1() With ActiveSheet.PivotTables("PriceHistory").PivotFields("Description") For i = 1 To .PivotItems.Count - 1 .PivotItems(.PivotItems(i).Name).DataRange.Select Next i End With End Sub It selects single total field. And loops through each (item...
  3. C

    Conditional formatting based off range of times in another cell

    I am looking for a way to automatically fill the cell color of one cell based on a range of times represented in another cell. So for example, I have column B which lists employee's schedules in the format of 8-4, 9-5, etc. These values are being referenced from another worksheet that contains...
  4. R

    Help an Air Force serviceman! Stuck on a conditional formatting formula now for 4 hours... I quit, please help!

    Hi there, I have a workbook with 40+ worksheets. The first tab is a Table of Contents (TOC) listing the title of each data worksheet (tabbed at bottom of spreadsheet). The remainder of worksheets are data. All I want to achieve is to turn a Table of Contents cell RED using conditional...

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