New answers tagged


For Windows version. Microsoft 365 Excel (Version 2004(Build 12730.20270) *Note the version is not the year - this is the 365 version in year 2020 You need to create 2 rules (one for each colour) Go to Home Tab -> Styles Group -> Conditional formatting -> Manage rules *Alternatively just type Conditional formatting in the search bar at the top New rule ...


Solution turned out to be (thanks to Sergei Baklan @ the Microsoft's Excel forums): =ISTEXT(N5) + (LEN(N5)>0) As anything I am outputting is counted as text, also when I am outputting ""


You can do it like the following: Select the cells that should be formatted. Create a new formatting rule On "Select a Rule Type", select "Format only cells that contain" On "Format only cells with", select equal to and set it to TRUE. Choose the color and font under "Format".


Make the font size of the text as 1 (Min possible) and that should hide all the numbers and just keep the colors visible


Select A151:E155. Use this formula as New Rule: =AND($E151="F",A151>1,A151<35) Apply an appropriate cell format. N.B. To justify the formula, purposely I've put 25 in cell B152, since E152 has P. You may adjust cell references in the formula as needed, also the marks to check.


In the conditional formatting in, say, cell A11, use this rule =AGGREGATE(3,3,A10)=0 Note the rule looks at the row directly above. The 3,3 parameter in AGGREGATE in plain English is show the COUNTA of visible cells. When A10 is hidden, the rule is TRUE and then you can set the conditional formatting in A11 on that. By the way, this works only if cell ...

Top 50 recent answers are included