MenuForum NavigationForumActivityLoginRegisterPost Reply: Conditional Formatting Issues When Converting Excel to Google Sheets <blockquote><div class="quotetitle">Quote from Guest on March 10, 2026, 4:27 am</div>Hey everyone, I need some help with a formatting problem I’m having. I built a spreadsheet in Excel to track contact dates at work. The system uses TODAY() function and conditional formatting to show different colors based on how long it’s been since contact. Here’s my setup for range C5:C150: <ol> <li><strong>Text value = REMOVE</strong> → Black background</li> <li><strong>Text value = ACTIVE</strong> → Blue background</li> <li><strong>Formula: AND(C5<=TODAY()-30, C5>TODAY()-45)</strong> → Orange background</li> <li><strong>Formula: C5<=TODAY()-45</strong> → Red background</li> <li><strong>Formula: C5>TODAY()-30</strong> → Green background</li> </ol> The issue happens when I upload to Google Sheets. In Excel, empty cells show up clear like they should. But in Google Sheets, any cell without a date gets colored red instead of staying blank. I tried using ISBLANK(C5) with no fill formatting, but it doesn’t work because the cells aren’t truly empty - they have formulas in them. There has to be a way to make cells with formulas but no actual date values display as blank instead of triggering the red formatting rule. Anyone know how to fix this Google Sheets formatting issue?</blockquote><br> Cancel
