Conditional formatting

[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.

 

[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?

 

[olasa]

Conditional formatting of cell A1 (Menu:Format>Conditiona
Formatting...):
http://www.datapigtechnologies.com/flashfiles/conditionalformatexcel.html

Is this the problem?
If Cellvalue (A1) is Less then D1 then Red?

Ol

 

[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

 

[cparaske]

Gingosh,

Try this:
Go to FORMULA IS and then type

=COUNTIF(A13,0)

choose RED in the PATTERN tab under FORMAT

A13 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

 

[greg7468]

Hi,
set the conditional formatting in A1 to

=SEARCH("older",D5)

HTH

 

[cparaske]

Gingosh,

Try this:
Go to FORMULA IS and then type

=COUNTIF(A13,0)

choose RED in the PATTERN tab under FORMAT

A13 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

 

[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.

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