Format a range of cells if another cell is not null

[Guest]

I would like to change the format of a range of cells in a row IF another value in the row is not null. The example I am trying to do is as follows

If there IS an exchange rate (R23 for example) then change the format of cells D23 to N23 to Italics

Any help would be appreciated.

 

[Frank abel]

Hi
try the following:
- select cells D23:N23
- goto 'Format - Conditional Format'
- enter the formula
=$R23<>""
- choose your format (italics)

-----Original Message-----
I would like to change the format of a range of cells in

a row IF another value in the row is not null. The example
I am trying to do is as follows:

If there IS an exchange rate (R23 for example) then

change the format of cells D23 to N23 to Italics.

 

[Guest]

I would like to change the format of a range of cells in
a row IF another value in the row is not null. The example
I am trying to do is as follows:

If there IS an exchange rate (R23 for example) then

change the format of cells D23 to N23 to Italics.


Gazza,

use conditional formatting for this:

Select the range D23:N23
Go to the Format menu > Conditional Formatting.
From the drop-down, select "Formula is", then type
=$r$23<>""
Click the "Format" button below the formula bar and select
the new formatting you want to apply.

Cheers, Pete.