New answers tagged

0 votes

Excel Conditional Formatting, alternating groups of three columns

I ended up creating 12 rules, two for each of the six column types. I used an AND() for green results and an OR() for red results, in order to correctly color blank cells. Green =AND(J4=$A4,J4<>...
WynnSmith's user avatar
1 vote
Accepted

Excel Conditional Formatting, alternating groups of three columns

If writing as few conditional formatting rules as possible is the goal, it is always possible to write supporting formulas in other cells in an unused part of the workbook, so that for any cell you ...
Wizard's user avatar
  • 32
0 votes

Excel conditional formatting linked cells blank formula

Select the row you want add the conditional formatting to Click conditional formatting Click + to add a new rule Make sure the row you want is populated in "Apply to range" You will want ...
Andrew's user avatar
  • 1
0 votes

Conditional formatting to highlight the whole row if a cell is left blank

Assuming the range starts at A2 (e.g. A2:AA20) then use a custom formula and lock the column you're evaluating with the $ as shown in the examples below. Either of these will work: =ISBLANK($A2) =$A2=...
2xj's user avatar
  • 101
1 vote
Accepted

IF formula for conditional formatting

Create a formula rule. In a conditional formatting formula rule, if the formula evaluates to TRUE, the formatting will be applied. In your case, you create the rule with C17 selected and enter a ...
FlexYourData's user avatar
  • 6,840
0 votes

Excel conditional formatting per row

Here are some ideas for if you follow the above advice (which is good advice) but there is still a problem. Sometimes, it is because a $ is very important. Sometimes, the '=' sign is forgotten when ...
Michael Curtis's user avatar

Top 50 recent answers are included