Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using conditional formatting
I have 2 columns H and I with numbers. I want to format column I such that
if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green and I want to do this for I6:I34. How do I go about doing this? Thanks. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using conditional formatting
Select cell you want to format
Select format conditional format Change to formula is =h6=i6 click format click pattern select color you want use format painter to copy to remaining cells "Ayo" wrote: I have 2 columns H and I with numbers. I want to format column I such that if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green and I want to do this for I6:I34. How do I go about doing this? Thanks. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using conditional formatting
Did that already. Didn't work. That why I'm here seeking more information.
"Pimamedic" wrote: Select cell you want to format Select format conditional format Change to formula is =h6=i6 click format click pattern select color you want use format painter to copy to remaining cells "Ayo" wrote: I have 2 columns H and I with numbers. I want to format column I such that if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green and I want to do this for I6:I34. How do I go about doing this? Thanks. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using conditional formatting
how do you have formula written in the conditional format
"Ayo" wrote: Did that already. Didn't work. That why I'm here seeking more information. "Pimamedic" wrote: Select cell you want to format Select format conditional format Change to formula is =h6=i6 click format click pattern select color you want use format painter to copy to remaining cells "Ayo" wrote: I have 2 columns H and I with numbers. I want to format column I such that if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green and I want to do this for I6:I34. How do I go about doing this? Thanks. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using conditional formatting
Formula:= "h6=i6"
Applies to =$I$6:$I$34 "Pimamedic" wrote: how do you have formula written in the conditional format "Ayo" wrote: Did that already. Didn't work. That why I'm here seeking more information. "Pimamedic" wrote: Select cell you want to format Select format conditional format Change to formula is =h6=i6 click format click pattern select color you want use format painter to copy to remaining cells "Ayo" wrote: I have 2 columns H and I with numbers. I want to format column I such that if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green and I want to do this for I6:I34. How do I go about doing this? Thanks. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using conditional formatting
try removing the quotes
"Ayo" wrote: Formula:= "h6=i6" Applies to =$I$6:$I$34 "Pimamedic" wrote: how do you have formula written in the conditional format "Ayo" wrote: Did that already. Didn't work. That why I'm here seeking more information. "Pimamedic" wrote: Select cell you want to format Select format conditional format Change to formula is =h6=i6 click format click pattern select color you want use format painter to copy to remaining cells "Ayo" wrote: I have 2 columns H and I with numbers. I want to format column I such that if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green and I want to do this for I6:I34. How do I go about doing this? Thanks. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using conditional formatting
forgot put = in front of h6
should be =h6=i6 "Ayo" wrote: Formula:= "h6=i6" Applies to =$I$6:$I$34 "Pimamedic" wrote: how do you have formula written in the conditional format "Ayo" wrote: Did that already. Didn't work. That why I'm here seeking more information. "Pimamedic" wrote: Select cell you want to format Select format conditional format Change to formula is =h6=i6 click format click pattern select color you want use format painter to copy to remaining cells "Ayo" wrote: I have 2 columns H and I with numbers. I want to format column I such that if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green and I want to do this for I6:I34. How do I go about doing this? Thanks. |
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using conditional formatting
Thanks so much. It worked.
"Pimamedic" wrote: forgot put = in front of h6 should be =h6=i6 "Ayo" wrote: Formula:= "h6=i6" Applies to =$I$6:$I$34 "Pimamedic" wrote: how do you have formula written in the conditional format "Ayo" wrote: Did that already. Didn't work. That why I'm here seeking more information. "Pimamedic" wrote: Select cell you want to format Select format conditional format Change to formula is =h6=i6 click format click pattern select color you want use format painter to copy to remaining cells "Ayo" wrote: I have 2 columns H and I with numbers. I want to format column I such that if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green and I want to do this for I6:I34. How do I go about doing this? Thanks. |
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
Using conditional formatting
YQW
"Ayo" wrote: Thanks so much. It worked. "Pimamedic" wrote: forgot put = in front of h6 should be =h6=i6 "Ayo" wrote: Formula:= "h6=i6" Applies to =$I$6:$I$34 "Pimamedic" wrote: how do you have formula written in the conditional format "Ayo" wrote: Did that already. Didn't work. That why I'm here seeking more information. "Pimamedic" wrote: Select cell you want to format Select format conditional format Change to formula is =h6=i6 click format click pattern select color you want use format painter to copy to remaining cells "Ayo" wrote: I have 2 columns H and I with numbers. I want to format column I such that if the value in adjecent cells are equal, i.e if I6=H6 for I6 font as green and I want to do this for I6:I34. How do I go about doing this? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formatting Conditional Formatting Icon Sets | Excel Discussion (Misc queries) | |||
Formatting cells in a column with conditional formatting? | Excel Discussion (Misc queries) | |||
Protect Cell Formatting including Conditional Formatting | Excel Discussion (Misc queries) | |||
conditional Formatting based on cell formatting | Excel Worksheet Functions | |||
Conditional Formatting that will display conditional data | Excel Worksheet Functions |