If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Fill color with if function
Hi.
I want to fill a cell with some color based on the value in other cell. if a24 then a1 is blue. Can anyone help me? thanks |
#2
|
|||
|
|||
Fill color with if function
Hi,
Use conditional formatting. Select A1 then Format|Conditional Formatting Formula is Enter the formula =A24 Pick you colour OK Mike "maz" wrote: Hi. I want to fill a cell with some color based on the value in other cell. if a24 then a1 is blue. Can anyone help me? thanks |
#3
|
|||
|
|||
Fill color with if function
You use conditional formatting to do this. Select A1, then click on
Format | Conditional Formatting and in the dialogue box select Formula Is rather than Cell Value Is. Enter this formula: =A24 Then click the Format button, then the Patterns tab (for background colours) and choose your colour. OK your way out. Hope this helps. Pete On Jul 30, 12:07*pm, maz wrote: Hi. I want to fill a cell with some color based on the value in other cell. if a24 then a1 is *blue. Can anyone help me? thanks |
#4
|
|||
|
|||
Fill Color with if function
I have a similar situation only I have 4 columns that I need all to be greater then 3 and then fill color to be used in my rank column. Is this possible?
|
#5
|
|||
|
|||
Fill Color with if function
On Jul 31, 5:30 pm, L N wrote:
I have a similar situation only I have 4 columns that I need all to be greater then 3 and then fill color to be used in my rank column. Is this possible? Use this formula in conditional formating for your rank column (adjust to suit your references), then copy formats down the column. =AND(B33,C33,D33,E33) |
Thread Tools | |
Display Modes | |
|
|