r/excel•
MGH_Job91

Conditional Formatting not working - Excel 365 desktop on a PC - picture of formulas used included - 2 of the 4 are working but the 2 with cells equal to a number is not highlighting correctly

unsolved

I want to highlight a section of columns A-G based on the number or text in column D. In the picture, Rows 3&4 from A-G should be grey, based on the conditional formatting formula of =$d3=13824104. Rows 5-9 of columns A-G should be blue based on the conditional formatting formula of =$d3=10026375. But they seem to be off by one row. What am I doing wrong?

Spreadsheet & conditional formatting

Posted Aug 4, 2025, 4:36 PM UTC

213
Loading comments…