0

I want to make the cell change color when any one of a range of cells is greater than its valve. This seems like pretty simple code to me, but when I test it out, the cell doesn't change color. It is first on the list to execute, so I'm sure its not being superseded by other formatting.

My "Format values where this is true:" has the following:

="$G5<max(I5:AB5)"

This code is also not working:

="int(isblank(F$5))=1"
  • F$5 looks wrong to me. Did you mean $F5? – Adam Aug 13 '14 at 19:22
  • Do you actually have quotes in there? Take them out. – G-Man Says 'Reinstate Monica' Aug 13 '14 at 20:34
  • don't worry about this one, I just found a much easier way to highlight blanks. ="int(isblank(F$5))=1" – nateAtwork Aug 13 '14 at 21:13
  • 1
    Do you need INT for the blank check? Try just =ISBLANK(F$5) – barry houdini Aug 13 '14 at 21:34
0

This is where conditional formatting shines. Click on the array you want to highlight. Click on Conditional Formatting > Highlight Cell Rules > Greater Than. In the box that appears type in

=MAX(I5:AB5)

and hit enter. That's it, they should turn red right away! (assuming you chose red as the color)

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.