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

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