+ Reply to Thread
Results 1 to 3 of 3

How to change cell colors based on data from other columns?

  1. #1
    Registered User
    Join Date
    05-23-2006
    Posts
    29

    How to change cell colors based on data from other columns?

    I know how to do this one cell at a time, changing A1 to green when C1>0.
    How do it tell the entire column to do the same with the A column and C column being attached in the same row?
    What I want to do is set up the A column (same row ) to change color based upon entries in the C column.
    I tried autofill and it impacts all of A column when C1 is >0
    Can I get some help with this?
    Thanks, John

  2. #2
    Forum Moderator Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,854
    John,

    Select column A.
    Click Format -> Conditional Formatting...
    Set Condition 1, Formula Is: =C1>0
    Click the Format button and apply the formatting you want shown
    Click OK to return to the sheet.

    A1's conditional format will be "=C1>0"
    A2's conditional format will be "=C2>0"

    Check for yourself to see.

  3. #3
    Registered User
    Join Date
    05-23-2006
    Posts
    29
    THanks Paul.
    Works very well!!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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