Conditional Formatting - Reference to multiple column
 

I need to highlight certain cells in column G for values less than 3 but only
do that when the corresponding row (cell value) in coumn E is greater than 3.

For example,

If G40 < 3 but E40 <=3 then G40 won't be highlighted
If G40 < 3 but E40 3 then G40 will be highlighted
If G40 3 then no action will be taken

I'm using Excel 2007.

Conditional Formatting - Reference to multiple column
 

use conditional formatting in cell G40 with 'FORMULA IS' option and use the
formula
=AND($G40<3,$E403)

"Aspiremind" wrote:

I need to highlight certain cells in column G for values less than 3 but only
do that when the corresponding row (cell value) in coumn E is greater than 3.

For example,

If G40 < 3 but E40 <=3 then G40 won't be highlighted
If G40 < 3 but E40 3 then G40 will be highlighted
If G40 3 then no action will be taken

I'm using Excel 2007.

Conditional Formatting - Reference to multiple column
 

How to put it if I want to select the entire column? Thanks

"Sheeloo" wrote:

use conditional formatting in cell G40 with 'FORMULA IS' option and use the
formula
=AND($G40<3,$E403)

"Aspiremind" wrote:

I need to highlight certain cells in column G for values less than 3 but only
do that when the corresponding row (cell value) in coumn E is greater than 3.

For example,

If G40 < 3 but E40 <=3 then G40 won't be highlighted
If G40 < 3 but E40 3 then G40 will be highlighted
If G40 3 then no action will be taken

I'm using Excel 2007.

Conditional Formatting - Reference to multiple column
 

select the range you want to highlight and enter the formula with reference
to the first cell. if you select G1:G100 then enter the forumula as
=AND($G1<3,$E13)
Excel will adjust the row number for other rows.

Alternatively you can select G40 and enter the formula given below
=AND($G40<3,$E403)
and then paint the format to other cells in the column.

"Aspiremind" wrote:

How to put it if I want to select the entire column? Thanks

"Sheeloo" wrote:

use conditional formatting in cell G40 with 'FORMULA IS' option and use the
formula
=AND($G40<3,$E403)

"Aspiremind" wrote:

I need to highlight certain cells in column G for values less than 3 but only
do that when the corresponding row (cell value) in coumn E is greater than 3.

For example,

If G40 < 3 but E40 <=3 then G40 won't be highlighted
If G40 < 3 but E40 3 then G40 will be highlighted
If G40 3 then no action will be taken

I'm using Excel 2007.