Conditional formatting one cell

%3CLINGO-SUB%20id%3D%22lingo-sub-3223268%22%20slang%3D%22en-US%22%3EConditional%20formatting%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3223268%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20Excel%20in%20Microsoft%20365.%20I%20want%20to%20conditionally%20format%20a%20single%20standalone%20cell%20(not%20a%20range%20of%20cells)%20to%20turn%20light%20red%20with%20dark%20red%20text%20when%20that%20cell%20has%20a%20value%20of%20less%20than%20or%20equal%20to%2080%20entered.%26nbsp%3B%20Everything%20I%20find%20talks%20about%20a%20range%20of%20cells.%20I%20am%20looking%20for%20just%20one%20single%20cell.%26nbsp%3B%20I%20have%20tried%20highlighting%20the%20cell%2C%20going%20to%20Conditional%20Formatting%20%26gt%3B%20Highlight%20Cells%20Rules%20%26gt%3B%20Less%20Than%20and%20then%20entering%20the%20value%20of%2081.%26nbsp%3B%20But%20all%20that%20does%20is%20turn%20the%20cell%20light%20red%20fill%20with%20dark%20red%20text%20regardless%20of%20the%20value%20entered.%20I've%20also%20tried%20Conditional%20Formatting%20%26gt%3B%20New%20Rule%20%26gt%3B%20Format%20only%20cells%20that%20contain%20and%20then%20entering%20selections%20for%20cell%20value%2C%20between%2C%200%20and%2081%2C%20but%20can't%20get%20it%20to%20highlight%20the%20cell%20with%20red%20fill%20with%20dark%20red%20text%20when%20a%20value%20between%200%20and%2081%20is%20entered.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3223268%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3223327%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3223327%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1320159%22%20target%3D%22_blank%22%3E%40KarlJ0916%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3D(B7%26gt%3B%3D0)*(B7%26lt%3B%3D81)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EThis%20rule%20for%20conditional%20formatting%20works%20in%20my%20sheet%20if%20the%20cell%20is%20B7.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3223376%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20one%20cell%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3223376%22%20slang%3D%22en-US%22%3EThank%20you.%20One%20small%20problem.%20The%20.pdf%20is%20in%20a%20language%20i%20don't%20recognize.%20German%20perhaps%3F%20At%20any%20rate%2C%20would%20you%20happen%20to%20have%20an%20English%20version%3F%3C%2FLINGO-BODY%3E
New Contributor

I am using Excel in Microsoft 365. I want to conditionally format a single standalone cell (not a range of cells) to turn light red with dark red text when that cell has a value of less than or equal to 80 entered.  Everything I find talks about a range of cells. I am looking for just one single cell.  I have tried highlighting the cell, going to Conditional Formatting > Highlight Cells Rules > Less Than and then entering the value of 81.  But all that does is turn the cell light red fill with dark red text regardless of the value entered. I've also tried Conditional Formatting > New Rule > Format only cells that contain and then entering selections for cell value, between, 0 and 81, but can't get it to highlight the cell with red fill with dark red text when a value between 0 and 81 is entered.

4 Replies

@KarlJ0916 

=(B7>=0)*(B7<=81)

This rule for conditional formatting works in my sheet if the cell is B7. 

Thank you. One small problem. The .pdf is in a language i don't recognize. German perhaps? At any rate, would you happen to have an English version?

@KarlJ0916 

Unfortunately i only use the german version of Excel. But i can tell you the path in the english version. First you should select the cell you want to format by clicking into this cell with your mouse and then follow this path:

Conditional formatting -> New rule -> Use a formula to determine which cells to format -> Format values where this formula is true

Once you have selected this path you can enter the rule for conditional formatting and select your format.

 

I tried the other options Highlight cell rule -> Less than (or Between) and New rule -> Format only cells that contain and they work as expected in my sheet.

Thank you very much. I was able to get that to work nicely. For some reason my spreadsheet does not like the Highlight cell rule option even though I've cleared the conditioning for the cell. But the other option works so I'll take it. I appreciate your help!