Conditional Formatting highlights blank cell even if criteria is not met

isblank() is not going to work , if the cell has a formula in which returns "" for some condition
BUT i dont know what you have in the cells

But from image C6<0.8 is true for Green and Red - stop if true not used - so that would show RED most of the time

so would be better to -

The forum does allow for spreadsheets to be uploaded direct to the forum -

Please see the Yellow Banner at the top of the page explaining how to attach a sample spreadsheet

A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.

Here are the instructions, found at the top of the page again

HOW TO ATTACH YOUR SAMPLE WORKBOOK:, Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

Sample Workbook.xlsx

I've attached a sample of the workbook I'm working on.

The conditional formatting works when it applies to just one cell in the table (Cell K14).
However, once I extend this to other cells in the table, they turn green/ red even when the cell is blank (Cell E6).

What I want to achieve with this conditional formatting is to highlight cells that are =>80% in green, cells <80% in red and leave empty cells blank.

Would appreciate your further help with this!

try
using
AND( cell <>"", cell<0.8)
AND( cell <>"", cell>=0.8)

what ranges are you applying to

JUST The % ??
C, E, G etc - just the ones labelled %

So as not to highlight the 2nd row of titles and just the columns with a % and to have just 1 set of conditions for the spreadsheet
RED
=AND(B6<0.8,B6<>"",RIGHT(B$5,1)="%",RIGHT(B6,1)<>"%")
GREEN
=AND(B6>=0.8,B6<>"",RIGHT(B$5,1)="%",RIGHT(B6,1)<>"%")


not sure what excel version 2308 is I suspect office 365, if you could update the profile to show the office version and its version that would be great

Thanks for sending over the file. I'm using M365 Apps for enterprise (Version 2308, Build 16731.20550).

Yes, I would like to only highlight the columns labelled with % (the cells without % will eventually be hidden), but only for Rows 6 and 14.

For the columns labelled with % in Rows 7-10 and 15-18, I would like them to be highlighted in font colour #833C0C / fill colour #FCE4D6 if the cell value is <0.8. If the cell is blank, the cell should likewise not be highlighted.

Also, is this working that you've done at the bottom of the workbook necessary when I apply the formatting formulas to my actual workbook?
Capture.PNG

Formula for CF in B6 and applied to B6:Y18
for red

Formula:

Please Login or Register  to view this content.

for Green

Formula:

Please Login or Register  to view this content.

Change font and fill colors as required.