How to make conditional formatting exclude blank cells

Our take

Conditional formatting in Excel can be a powerful tool for visualizing data, but it can also lead to confusion, especially with blank cells. In your case, it seems that the formatting rules are inadvertently applying to empty cells, causing them to appear green. To ensure that blank cells remain unformatted, you can adjust your conditional formatting rules. By adding a condition that explicitly checks for blank cells, you can maintain clarity in your working hours chart.

Making a working hours chart but I'm not very well versed in many Excel functions so I've been consulting google results for most, but I don't understand why conditional formatting is marking blank cells green for value >0. The detailed issue is as follows:

I have columns for for date (C), start time (D), end time (E), and the following (using row 5 for example):

Total time F5 =IF(D5;E5-D5;"") Number format: Time

Overtime: G5 =IF(OR(F40="";TIME(8;;)="");"";(F40-TIME(8;;))*24) Number format: General

I have set up conditional formatting in column G to color everything that is below 0 red, everything above 0 green, but all the blank cells with above formula applied are colored green too. Cells that equal 0 are left without color, as I intended.

My hope is that blank cells also remain white until they recieve a value. Is there a way to achieve that?

I appreciate all the help!

submitted by /u/ace_098
[link] [comments]

Read on the original site

Open the publisher's page for the full experience

View original article →

Tagged with

#Excel alternatives for data analysis#real-time data collaboration#real-time collaboration#natural language processing for spreadsheets#generative AI for data analysis#Excel compatibility#Excel alternatives#rows.com#AI formula generation techniques#google sheets#row zero#financial modeling with spreadsheets#formula generator