Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
reference another cell in conditional formatting | Excel Worksheet Functions | |||
cell reference changes and conditional formatting | Excel Worksheet Functions | |||
Multiple Column Conditional Formatting | New Users to Excel | |||
Conditional Formatting Reference / Inserting Rows | Excel Worksheet Functions | |||
Conditional Formatting, reference another column | Excel Worksheet Functions |