Conditional formatting

G

Gingosh

Is it possible to do the following:

Example:

If cell D1 = “older”
Then cell A1 gets highlighted in red

Please let me know if this is possible. :confused:
 
C

cparaske

Gingosh,

It's possible, but what are you trying to do? You can write an IF
statement that puts some value into A1 that would then trigger the
conditional formatting.

Can you give us a little more information?
 
G

Gingosh

Basically I have a list of people, from which I am collecting money fo
various work related social outings, and basically I want their name
(located in A1 and so on) to be highlighted red should their balanc
(in cell D1 and so on) not equal 0, so therefore I know they still hav
an outstanding balance
 
C

cparaske

Gingosh,

Try this:
Go to FORMULA IS and then type

=COUNTIF(A1:D3,0)

choose RED in the PATTERN tab under FORMAT

A1:D3 is the range of your data, so you should modify to take int
account all cells. This will highlight the whole row where a perso
has 0 entered in column D.

HT
 
C

cparaske

Gingosh,

Try this:
Go to FORMULA IS and then type

=COUNTIF(A1:D3,0)

choose RED in the PATTERN tab under FORMAT

A1:D3 is the range of your data, so you should modify to take int
account all cells. This will highlight the whole row where a perso
has 0 entered in column D. It's the inverse of what you wanted (i
will RED out people who owe 0), but you will be able to distinguis
between those that have paid and those that haven't.

HT
 
R

Ron Rosenfeld

Is it possible to do the following:

Example:

If cell D1 = “older”
Then cell A1 gets highlighted in red

Please let me know if this is possible. :confused:
Click to expand...

1. Select A1
2. Format/Conditional Formatting/Formula Is:
=D1="older"
3. Select the Format button and format it as you wish.
--ron
 
Top