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
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?
Posted Aug 4, 2025, 4:36 PM UTC
213