1

I have a sheet tracking activity scores for players across multiple accounts in a game I play.

I am trying to format the scores so that the monthly cells (Columns I through T) will be red if the number for the month is less than the minimum required (column B), however, nothing I have tried seems to work from other similar questions I have looked at.

I tried a simple =I2<B2 but that ignored the 0 cells, which could be because they are results of a function which returns 0 if vlookup returns an error?

Using the Less than option in the drop down returns ever weirder results with only 2 of the cells not being red, both of which should actually be red...

I'm learning as I go so any advice would be appreciated!

Data Sheet

Basic Less than formatting

0
  • select cell I2
  • set conditional format rules as:

...not sure which one you need:

=IF(I2>$B2,TRUE,FALSE)

or

=IF(I2<$B2,TRUE,FALSE)

https://docs.google.com/spreadsheets/d/

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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