Results 1 to 5 of 5

Conditional Formatting

Threaded View

melbin Conditional Formatting 01-18-2018, 05:00 PM
Mazzaropi Re: Conditional Formatting 01-18-2018, 05:44 PM
Aardigspook Re: Conditional Formatting 01-18-2018, 05:45 PM
Aardigspook Re: Conditional Formatting 01-18-2018, 05:46 PM
AliGW Re: Conditional Formatting 01-18-2018, 05:50 PM
  1. #1
    Registered User
    Join Date
    10-15-2017
    Location
    Bangalore, India
    MS-Off Ver
    Ms office 10
    Posts
    35

    Conditional Formatting

    Hi,

    Can anyone help me to color the attached spreadsheet using conditional formatting.

    D3:H22 is the range. The condition is if the value in the cell E3 is greater than the value in the cell D3, E3 should be in green. If the value in the cell E3 is lesser than the value in the cell D3, E3 should be in red. And the cell E3 is blank, it should colour yellow.

    Likewise i need to colour D3:H33 based on this condition.

    To be specific, the value in a cell is greater than the value in the adjacent cell (left side cell) it should colour green and if it is less colour red and if any cell is blank, colour yellow.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Override conditional formatting (in general, without changing the conditional formatting)
    By Stormin' in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-21-2017, 07:15 AM
  2. Replies: 1
    Last Post: 12-08-2016, 03:14 PM
  3. Conditional Formatting Removing Previous Conditional Formatting?
    By CravingGod in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-04-2016, 01:02 PM
  4. Replies: 6
    Last Post: 01-08-2016, 06:44 PM
  5. Opening xlsm files with conditional formatting opens with removed conditional formatting
    By Martijn.Steenbakker in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-07-2014, 05:38 AM
  6. Replies: 1
    Last Post: 09-20-2013, 06:23 PM
  7. Replies: 3
    Last Post: 05-15-2012, 04:13 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