Conditional format based on data from another column
Hi
Yesterday I asked about the possibility of conditional formatting a range of 20 random numbers into 2 different formats. Thank you for that, but now it seems that 3 of my 20 numbers are now requiring a different cell to be highlighted in yet another colour. Currently the situation is as follows:- Column G has a list of random numbers ranging from 1-20, with columns either side pertaining to the random number located in the relevant cell in Column G. It now appears that 3 numbers in this random list do not require highlighting in Column G and have amended the condition formatting for Column G accordingly, but do require the data located in Column I, relevant to the random number to be highlighted in a 3rd colour. Is there any way I may be able to get the cells in Column I to highlight in a colour subject to the random numbers in Column G (being 7, 13 & 16)? Hope this makes some sense. Many thanks. Ellie |
Hi, Ellie. Use conditional formatting with a formula.
http://www.officearticles.com/excel/...ft_ excel.htm ************ Anne Troy www.OfficeArticles.com "Ellie" wrote in message ... Hi Yesterday I asked about the possibility of conditional formatting a range of 20 random numbers into 2 different formats. Thank you for that, but now it seems that 3 of my 20 numbers are now requiring a different cell to be highlighted in yet another colour. Currently the situation is as follows:- Column G has a list of random numbers ranging from 1-20, with columns either side pertaining to the random number located in the relevant cell in Column G. It now appears that 3 numbers in this random list do not require highlighting in Column G and have amended the condition formatting for Column G accordingly, but do require the data located in Column I, relevant to the random number to be highlighted in a 3rd colour. Is there any way I may be able to get the cells in Column I to highlight in a colour subject to the random numbers in Column G (being 7, 13 & 16)? Hope this makes some sense. Many thanks. Ellie |
Yes, you can apply the conditional formatting in column I, and use a
formula to refer the the contents of column G. For example, with cell I2 as the active cell, choose FormatConditional Formatting From the first dropdown, choose Formula Is In the formula box, type: =G2=7 Click the Format button, and add the formatting you want for that number. Click the Add button, and do the next two conditions. You can use the Format Painter to copy the formatting to the remaining cells in column I. There's an example he http://www.contextures.com/xlCondFormat02.html Ellie wrote: Hi Yesterday I asked about the possibility of conditional formatting a range of 20 random numbers into 2 different formats. Thank you for that, but now it seems that 3 of my 20 numbers are now requiring a different cell to be highlighted in yet another colour. Currently the situation is as follows:- Column G has a list of random numbers ranging from 1-20, with columns either side pertaining to the random number located in the relevant cell in Column G. It now appears that 3 numbers in this random list do not require highlighting in Column G and have amended the condition formatting for Column G accordingly, but do require the data located in Column I, relevant to the random number to be highlighted in a 3rd colour. Is there any way I may be able to get the cells in Column I to highlight in a colour subject to the random numbers in Column G (being 7, 13 & 16)? Hope this makes some sense. Many thanks. Ellie -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
Conditional format based on data from another column
Only problem with this Is I have a listing of 15, a sort by number if you
will, the column will be any number between 1 and 15, I want the corresponding row to change to a particular background based on that particular number 1 through 15, in formatting it only allows me to add three, how do I get the system to allow for all 15? Thank you for your help. -- Judy Rose Cohen "Debra Dalgleish" wrote: Yes, you can apply the conditional formatting in column I, and use a formula to refer the the contents of column G. For example, with cell I2 as the active cell, choose FormatConditional Formatting From the first dropdown, choose Formula Is In the formula box, type: =G2=7 Click the Format button, and add the formatting you want for that number. Click the Add button, and do the next two conditions. You can use the Format Painter to copy the formatting to the remaining cells in column I. There's an example he http://www.contextures.com/xlCondFormat02.html Ellie wrote: Hi Yesterday I asked about the possibility of conditional formatting a range of 20 random numbers into 2 different formats. Thank you for that, but now it seems that 3 of my 20 numbers are now requiring a different cell to be highlighted in yet another colour. Currently the situation is as follows:- Column G has a list of random numbers ranging from 1-20, with columns either side pertaining to the random number located in the relevant cell in Column G. It now appears that 3 numbers in this random list do not require highlighting in Column G and have amended the condition formatting for Column G accordingly, but do require the data located in Column I, relevant to the random number to be highlighted in a 3rd colour. Is there any way I may be able to get the cells in Column I to highlight in a colour subject to the random numbers in Column G (being 7, 13 & 16)? Hope this makes some sense. Many thanks. Ellie -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
All times are GMT +1. The time now is 03:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com