+ Reply to Thread
Results 1 to 9 of 9

How to Apply Conditional Formatting Here

  1. #1
    Registered User
    Join Date
    12-27-2011
    Location
    Bangladesh
    MS-Off Ver
    Excel 2016
    Posts
    65

    How to Apply Conditional Formatting Here

    Hi Everyone,
    Please have a look at my problem.
    In a sheet named Duty, I have Available Invigilators' number from G23:O23
    In the same sheet below one row, I have Required Invigilators' number from G25:O25
    Conditional Formatting.png
    I want to apply conditional Formatting in G23:O23 based on the corresponding cells G25:O25 with reference to the values in G25:O25.

    Conditions:
    1. If the values in G23:O23 are same to the corresponding Required number, the cells in G23:O23 will be Green.
    2. If the values in G23:O23 are less than the corresponding Required number, the cells in G23:O23 will be Red.
    3. If the values in G23:O23 are greater than the corresponding Required number, the cells in G23:O23 will be Yellow.

    Is it possible with Conditional Formatting?
    If yes, what is the process?
    If not, what is the alternative?

    A screenshot is given here for your convenience.
    Conditional Formatting.png
    Please Help.

    With Thanks in Advance
    Haque

  2. #2
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,289

    Re: How to Apply Conditional Formatting Here

    I think it is possible
    Please upload your excel file for futher help.
    Willem
    English is not my native language sorry for errors
    Please correct me if I'm completely wrong

  3. #3
    Registered User
    Join Date
    12-27-2011
    Location
    Bangladesh
    MS-Off Ver
    Excel 2016
    Posts
    65

    Re: How to Apply Conditional Formatting Here

    Here is the file Link
    https://onedrive.live.com/redir?resi...nt=file%2cxlsx
    Sorry I dont know why file attachment is not working for me

    Regards
    Haque

  4. #4
    Registered User
    Join Date
    12-27-2011
    Location
    Bangladesh
    MS-Off Ver
    Excel 2016
    Posts
    65

    Re: How to Apply Conditional Formatting Here

    Quote Originally Posted by popipipo View Post
    I think it is possible
    Please upload your excel file for futher help.
    Here is the file Link
    https://onedrive.live.com/redir?resi...nt=file%2cxlsx
    Sorry I dont know why file attachment is not working for me

    Regards
    Haque

  5. #5
    Forum Expert
    Join Date
    12-11-2011
    Location
    Netherlands
    MS-Off Ver
    office 365
    Posts
    3,289

    Re: How to Apply Conditional Formatting Here

    You can upload your file using (paperclip doesn't work)

    Additional options
    Manage Attachments

  6. #6
    Registered User
    Join Date
    12-27-2011
    Location
    Bangladesh
    MS-Off Ver
    Excel 2016
    Posts
    65

    Re: How to Apply Conditional Formatting Here

    Quote Originally Posted by popipipo View Post
    You can upload your file using (paperclip doesn't work)

    Additional options
    Manage Attachments
    Attachment 457506
    Here is the File
    Please help me solve the problem

    Regards
    Haque

  7. #7
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,148

    Re: How to Apply Conditional Formatting Here

    Red

    =G23<G25

    Green

    =G23=G25

    Yellow

    =G23>G25

    See attached
    Attached Files Attached Files

  8. #8
    Registered User
    Join Date
    12-27-2011
    Location
    Bangladesh
    MS-Off Ver
    Excel 2016
    Posts
    65

    Re: How to Apply Conditional Formatting Here

    Quote Originally Posted by JohnTopley View Post
    Red

    =G23<G25

    Green

    =G23=G25

    Yellow

    =G23>G25

    See attached
    Hi JohnTopley,

    Thanks for your solution.
    As I am new in this section of Excel, would you please explain a couple of lines of formula given above?

    Regards
    Haque

  9. #9
    Registered User
    Join Date
    12-27-2011
    Location
    Bangladesh
    MS-Off Ver
    Excel 2016
    Posts
    65

    Re: How to Apply Conditional Formatting Here

    Hi JohnTopley,

    At last I have been able to do the job.

    Thank you again

    Regards
    Haque

+ 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. Apply Conditional Formatting on Row
    By Naghman in forum Excel General
    Replies: 3
    Last Post: 09-14-2015, 05:56 AM
  2. [SOLVED] Apply conditional formatting to rows below
    By ibenegal in forum Excel General
    Replies: 3
    Last Post: 01-07-2015, 03:11 AM
  3. Explain Conditional Formatting to me and how I can apply it?
    By narski in forum Excel Formulas & Functions
    Replies: 26
    Last Post: 08-13-2014, 03:40 AM
  4. [SOLVED] IF (something is a supplier) AND (value is) then apply conditional formatting?!
    By mra1984 in forum Excel Formulas & Functions
    Replies: 15
    Last Post: 12-02-2013, 06:02 PM
  5. [SOLVED] Want to apply conditional formatting
    By mshtuhin in forum Excel General
    Replies: 5
    Last Post: 07-04-2012, 07:41 AM
  6. Replies: 1
    Last Post: 11-12-2010, 03:18 PM
  7. Replies: 2
    Last Post: 09-02-2009, 07:46 AM

Tags for this Thread

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