Conditional formatting questions.

1)
Is there a way for me to set the conditional formatting in excel so that the formatting would be affected by the contents of another cell?

For example, if I were to enter ‘red’ in cell A1, cell B1 would have red for its cell shading.

2)
Just to ask, is there a way to add more than 3 conditional formatting conditions to any particular cell?

Thanks!!

thanks!!

Is there any way to modify the formula to make it dynamic, for example

The conditional formatting for cell b1 is:
=$A$1='Red"

if i want this to be similar for all rows (cell B2's formatting is =$A$2='Red") is there any way i can modify the fomular so that it can latch on to the row (and modify the formula accordingly) to prevent me from manually retyping?

Originally Posted by dominicb

Hi lordfa9



Yes. Just take the "$" signs out of the formula thus :
=$A$1="red"

and copy it down.

HTH

DominicB

i dont really get what you mean, do i need to take out the $ signs from the formula till it becomes

Please Login or Register  to view this content.

how do i copy it? do i use the "mouse@the bottom right hand of cell corner and drag" or the copy->paste special methods?

or a regular copy and paste?

ok that works for me but the prob is that the cells that i want to apply this conditional formatting to already have data in it. Is there any way to apply the formatting without losing the data?

well i have two columns of cells A and B

a will be the one which determines the conditional formatting of B

the formula will be something like this:

Conditional formatting for BX-> =AX="value"

where X is the row number

the idea is to apply this formatting for about the 100+rows of the worksheet

but the problem is that the rows already have data so i don't think autofill is an option

right click on source cell and select copy

Highlight the destination range and right click and select paste special

Select formatting >OK

This will just copy the formattiing and leave the contents unaltered

Ed

thanks edmac, i'll lose my merged cells but it sure beats having to manually retype that formatting

Originally Posted by oldchippy

If I understand you correctly, you have numbers in columns A and B, if the number in column B is greater than column A, you want to hightlight the cell?

If that is the case, then select B1, go to Format > Conditional format, select Cell is..greater than, then click in cell A1, then select the formatting required > OK.

Now this has set the formatting to B1, with B1 selected, click the Painbrush icon and then select B2:B100 or what ever your range is.

You should now have all cells in column B highlighted if the value is greater than the equivalent cell in column A.

not really the idea is have the cells linked in this way

Conditional formatting for B1-> =A1="value"
Conditional formatting for B2-> =A2="value"
...
...
...
and so on