+ Reply to Thread
Results 1 to 2 of 2

Google sheets: Conditional formatting (same concept, different cells)

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

    Google sheets: Conditional formatting (same concept, different cells)

    Hi all,

    Can anyone tell me if there is a quick and easy way for me to do the following.

    I have a weight loss spreadsheet.

    Cell B3 has weight for week 1, C3, week 2, C4: week 3 and so on
    I want to setup conditional formatting that says if it is greater than the previous week, highlight the cell in red, less than = green, equal to = orange.
    Can I do this with google sheet formatting and then apply it to all my cells without having to do the setting for each cell?

    here is my sheet

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

    R.



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

    Re: Google sheets: Conditional formatting (same concept, different cells)

    Hi all,

    Solution was:

    B3:L1001

    =AND(B3<A3,ISNUMBER(B3))
    And apply the formatting
    thank you!

+ 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. [SOLVED] Google Sheets - Formula or conditional formatting help - a "today's date" formula?
    By Nolarobinson in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 6
    Last Post: 04-25-2018, 07:09 AM
  2. [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
  3. 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
  4. 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
  5. Help required in conditional formating Google Sheets
    By balu2021 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 04-06-2017, 04:05 AM
  6. Replies: 13
    Last Post: 07-09-2014, 04:10 PM
  7. [SOLVED] Conditional Formatting when cells are from certain sheets
    By mpgibson in forum Excel General
    Replies: 2
    Last Post: 06-08-2012, 10:55 AM

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