Results 1 to 6 of 6

Thread: Filling A Number Of Cells Based On Numerical Value

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 02-13-2013, 09:44 PM #6
    Ryan_Bernal
    Ryan_Bernal is offline
    Member Ryan_Bernal's Avatar
    Join Date
    Dec 2012
    Posts
    37
    Rep Power
    0
    Quote Originally Posted by Kevin@Radstock View Post
    Hi Ryan_Bernal

    Another solution for the formatting might be.
    Rule 1 Green: =COLUMNS($E$3:E3)<=$B$3
    Rule 2 Red: =AND(E$3<>"",COLUMNS($E$3:E3)>$B$3)

    Kevin
    Thanks bro.

    https://www.youtube.com/channel/UCnxwq2aGJRbjOo_MO54oaHA
    Last edited by DocAElstein; 06-10-2023 at 03:37 PM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Sum Of A Row of Cells In Multiple Columns Based On Criteria And Column Index
    By excel_learner in forum Excel Help
    Replies: 3
    Last Post: 05-23-2013, 11:17 PM
  2. Make cells visible based on Data Validation criteria
    By IJC in forum Excel Help
    Replies: 4
    Last Post: 05-05-2013, 04:01 AM
  3. Need a way to conditionally format a cell based on an adjacent cells value.
    By Orestees in forum Excel Help
    Replies: 2
    Last Post: 01-24-2013, 09:03 PM
  4. Concatenating array into cells based on conditions
    By Lis7 in forum Excel Help
    Replies: 1
    Last Post: 12-04-2012, 08:56 AM
  5. Format Cells Based on Given Input
    By Rajesh Kr Joshi in forum Excel Help
    Replies: 10
    Last Post: 08-23-2011, 11:19 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
  •  

Forum Rules