Conditional Formatting in Excel

Microsoft Excel 2003 (full product)
February 21, 2012 at 05:54:10
Specs: Windows XP
I have a spreadsheet for organising my friends hen night. I want to play around with a conditional formatting option, i.e Column A is the name, and Column D is left with either a date or a simple yes to the deposit being paid. I would like the appropriate persons name in Column A to turn Green when date/or YES (whichever is better) is placed in Column D. I can then hopefully copy this to show that the person has fully paid their outstanding balance when Column G = £0. Not sure whether I have the right things in the right place or whether I need to set this up with new values. and also a newbie to excel. More just playing around really.

See More: Conditional Formatting in Excel

Report •

#1
February 21, 2012 at 11:51:54
Conditional Formats are applied when the rule (or formula) evaluates to TRUE.

So something like =A1="YES" would work for a cell containing YES.

Checking specifically for a date can be a bit more cumbersome since there isn't anything like =ISDATE(A1) built into Excel.

How important is it that you Format Column A based on whether or not a cell contains a date?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
February 21, 2012 at 18:18:10
From your comments, I think what you would need is a formula that tracks column G.

the person has fully paid their outstanding balance when Column G = £0

So something like this should work:

Conditional Formatting 2003

1) – Select the cell or range of cells, in your case cell A1
2) - On the Menu Bar: Select Format
3) - Select Conditional Formatting
4) – Change “Cell Value is” to “Formula Is”
5) – Enter the formula:

=IF(G1=0,TRUE,FALSE)
or the shorter version: =G1=0

Sub Menu Format :
6) - Patterns
7) - Choose Green
8) - Press OK

======================================================================

Conditional Formatting 2007

1) Select your cell or range of cells, in your case A1
2) On the ribbon click Conditional Formatting
3) Click on New Rules, it’s near the bottom of the dialog box.
4) Click Use Formula to determine which cells to format.
5) Enter the formula:

=IF(G1=0,TRUE,FALSE)
or the shorter version: =G1=0

6) Click on the Format button
7) Select the Fill Tab
8) Select a Green color
9) Click OK
10) Click OK

Now when the member has paid in full,
and the balance in G1 equals Zero,
the name in A1 will turn green.

MIKE

http://www.skeptic.com/


Report •
Related Solutions


Ask Question