Conditional Format based on another cell

  • Thread starter Thread starter oldjay
  • Start date Start date
O

oldjay

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
 
use <format> <conditional format><formula is..>
=OR(AB28=1,AB28=2)
and select the font colour format
 
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
 
Thanks

Shane Devenshire said:
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
Click to expand...
 
Back
Top