Hi,

How can I format a cell depending on the value of another cell?

Many thanks.
Wilfried

See http://www.contextures.com/xlCondFormat01.html

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"Wilfried" wrote in message
...
Hi,

How can I format a cell depending on the value of another cell?

Many thanks.
Wilfried

select "formula is" instead of "cell value is"

Example:
select cell A1
click Format-Conditional Formatting
Select "formula is"
Enter the following formula
=$B$14

When B1 has a value greater than 4, A1 will have the conditional formatting
applied.

"Wilfried" wrote:

Hi,

How can I format a cell depending on the value of another cell?

Many thanks.
Wilfried

Thank you for the reply. It solved my problem !
Best wishes for 2007


"Wilfried" wrote in message
...
Hi,

How can I format a cell depending on the value of another cell?

Many thanks.
Wilfried