+ Reply to Thread
Results 1 to 9 of 9

Conditional formatting minus figures (Google sheets)

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Conditional formatting minus figures (Google sheets)

    Hi guys,

    Using google sheets.. what is the formula to write:

    If Cell J18 is minus 0.0kg, highlight it in red?

    Thank you!
    Thanks,

    R.



  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent SAC
    Posts
    8,886

    Re: Conditional formatting minus figures (Google sheets)

    The rule would just be for cell value is less than 0, I believe.

  3. #3
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: Conditional formatting minus figures (Google sheets)

    Hi rorya

    https://docs.google.com/spreadsheets...it?usp=sharing

    Here is my sheet. the rule does not work in cell J18

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: Conditional formatting minus figures (Google sheets)

    Conditional formatting is greyed out ...
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  5. #5
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: Conditional formatting minus figures (Google sheets)

    Hi Ali,

    Sorry permission remove. try again please?

    Thank you!!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: Conditional formatting minus figures (Google sheets)

    Still no go - sorry!

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: Conditional formatting minus figures (Google sheets)

    OK, so other cells are unlocked. You have the correct rule set up, but you have it set to highlight the cell green, not red.

  8. #8
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    Office 365
    Posts
    831

    Re: Conditional formatting minus figures (Google sheets)

    Thanks Ali, I think I just needed to try and get my 'thinking' about the logic/concept right. So i have kept this as green now.. thank you for helping me think about this!

  9. #9
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,401

    Re: Conditional formatting minus figures (Google sheets)

    Sometimes it's best to erase all the rules you have set up and start again.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Google sheets: Conditional formatting
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 7
    Last Post: 08-07-2018, 09:39 AM
  2. [SOLVED] Google sheets: Conditional formatting (same concept, different cells)
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-03-2018, 10:40 AM
  3. Positive, negative, neutral numbers - conditional formatting (Google sheets)
    By rayted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 08-03-2018, 10:13 AM
  4. [SOLVED] Google Sheets: conditional formatting for cell containing letters and numbers
    By jher001 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 7
    Last Post: 04-13-2018, 03:18 PM
  5. Google Sheets - Tricky conditional formatting with two requirements
    By ilorenzo in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 07-19-2017, 08:53 PM
  6. Conditional formatting for multiple work schedules [Google Sheets]
    By theclarkmeister in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 0
    Last Post: 06-30-2017, 06:34 PM
  7. Replies: 13
    Last Post: 07-09-2014, 04:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1