Results 1 to 10 of 10

Conditional formatting using if function

Threaded View

  1. 01-18-2018, 01:42 AM #1
    melbin
    melbin is offline
    Registered User
    Join Date
    10-15-2017
    Location
    Bangalore, India
    MS-Off Ver
    Ms office 10
    Posts
    35

    Conditional formatting using if function

    Hi There,

    I need to colour the attached excel sheet(D3:H23) using conditional formatting and IF function. Following is the condition. If E3 is greater than D3, colour Green. If E3 less than D3, colour Red. If E3 is blank colour yellow.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional Formatting if function
    By exclusiveleex in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-15-2017, 03:37 PM
  2. Using a function in Conditional Formatting
    By bryanwhalen in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-02-2012, 09:13 AM
  3. AND() function in conditional formatting
    By demonfly100 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 08-21-2012, 06:03 AM
  4. [SOLVED] Conditional formatting and IF function
    By pjlau in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-30-2012, 10:07 AM
  5. [SOLVED] If function & conditional formatting
    By spursrule68 in forum Excel General
    Replies: 20
    Last Post: 05-31-2012, 08:13 AM
  6. Conditional formatting with NOW() function
    By richbriggs in forum Excel General
    Replies: 3
    Last Post: 05-10-2012, 08:01 PM
  7. IF Function and Conditional Formatting
    By excelRookie06 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-27-2007, 09:16 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1