Conditional Formatting with Formula Not Working for One Row But All Others Work

D

dmarchand1

New Member
Joined
Jan 11, 2022
Messages
8
Office Version
  1. 365
Platform
  1. Windows
  2. Web
Hello - I am using Excel to create a simple Gantt chart for projects. Below is a snapshot of the conditional formatting rule/formula, and another snapshot of the the gantt chart sheet being produced by the formatting. For some reason, one of the rows (Row 41) will not format (fill with color) even though it is in the range (I have highlighted in yellow below). I have tried deleting the row and putting it back and it is still not working. Any thoughts suggestions?

1698695822722.png

1698696941947.png
 
Sort by date Sort by votes
Glad to help! Conditional formatting and date arithmetic are two areas of interest for me, so it's really interesting when they both happen at once.
 
Upvote 0

Excel Facts

Is there a shortcut key for strikethrough?
Ctrl+S is used for Save. Ctrl+5 is used for Strikethrough. Why Ctrl+5? When you use hashmarks to count |||| is 4, strike through to mean 5.
You must log in or register to reply here.

Similar threads

D
  • Question
conditional formatting
Replies
1
Views
46
etaf
etaf
L
  • Solved
Conditional Formatting in Excel Table and Ignore Blanks Not Working
Replies
3
Views
278
Joe4
Joe4
G
  • Solved
How to write a Conditional Formatting Formula inside an Excel Table
Replies
3
Views
46
SanjayGMusafir
SanjayGMusafir
N
  • Question
Why Highlight Conditional Formatting Rule is not working?
Replies
3
Views
538
Fluff
Fluff
R
  • Solved
Using conditional formatting to highlight the row of a cell containing specific text.
Replies
4
Views
303
etaf
etaf

Forum statistics

Threads
1,215,086
Messages
6,123,031
Members
449,092
Latest member
ikke

Share this page

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