Conditional Format based on another cell
 

I have an input cell AD28 that I want to change the text to white if the
value in AB28 equals a1 0r 2

oldjay

Conditional Format based on another cell
 

use <format <conditional format<formula is..
=OR(AB28=1,AB28=2)
and select the font colour format
--
Greetings from New Zealand

"oldjay" wrote in message
...
I have an input cell AD28 that I want to change the text to white if the
value in AB28 equals a1 0r 2

oldjay

Conditional Format based on another cell
 

Hi,

In 2003:
1. Select the cells you want to format, AD28 in your case
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=OR(AB28=0,AB28=2)
5. Click the Format button
6. Choose a color on the Patterns tab (or any available option)
7. Click OK twice.

In 2007:
1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, New Rule
3. Choose Use a formula to determine which cell to format
4. In the Format values where this formula is true enter the following
formula:
=OR(AB28=0,AB28=2)
5. Click the Format button and choose a format.
6. Click OK twice
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"oldjay" wrote:

I have an input cell AD28 that I want to change the text to white if the
value in AB28 equals a1 0r 2

oldjay

Conditional Format based on another cell
 

Thanks

"Shane Devenshire" wrote:

Hi,

In 2003:
1. Select the cells you want to format, AD28 in your case
2. Choose Format, Conditional Formatting
3. Choose Formula is from the first drop down
4. In the second box enter the formula:
=OR(AB28=0,AB28=2)
5. Click the Format button
6. Choose a color on the Patterns tab (or any available option)
7. Click OK twice.

In 2007:
1. Highlight all the cells on the rows you want formatted
2. Choose Home, Conditional Formatting, New Rule
3. Choose Use a formula to determine which cell to format
4. In the Format values where this formula is true enter the following
formula:
=OR(AB28=0,AB28=2)
5. Click the Format button and choose a format.
6. Click OK twice
--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"oldjay" wrote:

I have an input cell AD28 that I want to change the text to white if the
value in AB28 equals a1 0r 2

oldjay