Hot answers tagged

1

Select the column B where you have to apply the conditional formatting using a formula, You can write the following formula in conditional formatting, format values where this formula is true: =And(isblank(B2),C2="Yes") and format Orange =AND(NOT(ISBLANK(B2)),B2<>D2) and format red where B2 is the column of empty cells and C2 is Yes B2 will be Orange and ...


1

One way I can think to do this would be combining a formula with conditional formatting. So, paste the following formula in B1: =IF(COUNTIF(B2:B7,"No")=4,"red",IF(COUNTIF(B2:B7,"Yes")=4,"green","")) That formula will enter "red" in cell B1 if there are 4 cells in range B2:B7 which are "No". Similarly, if 4 cells in the range say "Yes", then the cell will ...


1

You should trim the time difference to whole seconds resolution to avoid (invisible) errors in the IF clause. Use =TRIM((F6-H6)*86400)/86400 in cell K6 to cut off any amount smaller than a second. Second, if you just want to show the difference in minutes (instead of hh:mm) then use mm in a custom format - you don't need to replace one numerical value ...


1

Yes it is possible because I just did it. First, you highlight the cells you want to format. Then you take this formatting rule and do it 3 separate times (or as many different times as you need it for each color scheme). Your rule will be "Specific Text - ending with - INSERT YOUR UNIQUE ENDING NUMBERS HERE. I created a red/yellow/green pattern for mine ...



Only top voted, non community-wiki answers of a minimum length are eligible