Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-20 Thread Ahmed Emam
Thanks On Sun, Jul 20, 2014 at 10:06 AM, Vaibhav Joshi wrote: > Just copy the cell in which you have applied conditional formatting, after > that select cells where you need to apply same formatting, then Paste > special formatting to it by right clicking on selected cells. > > Check this attac

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-20 Thread Vaibhav Joshi
Just copy the cell in which you have applied conditional formatting, after that select cells where you need to apply same formatting, then Paste special formatting to it by right clicking on selected cells. Check this attachment. Cheers!! On Sun, Jul 20, 2014 at 2:51 AM, Ahmed Emam wrote: > I

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-19 Thread Ahmed Emam
I applied the formula as you did to one cell, but now i want to apply it to a whole table as attached. I applied it to Cell C3 to be based on O, P, Q in the attached file. Now i want to apply it to the cell range from C3 to N3 and C22 to N22. Brief: the formula to apply on every row from C to N

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-18 Thread Vaibhav Joshi
Cheers. . On Jul 18, 2014 4:50 PM, "Ahmed Emam" wrote: > Thanks for your support > > > On Fri, Jul 18, 2014 at 9:40 AM, Vaibhav Joshi wrote: > >> Hi >> >> Check conditional format set in sheet.. >> >> First select Cell A1, then conditional formting and Manage Rules... >> >> Cheers!! >> >> >> >>

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-18 Thread Ahmed Emam
Thanks for your support On Fri, Jul 18, 2014 at 9:40 AM, Vaibhav Joshi wrote: > Hi > > Check conditional format set in sheet.. > > First select Cell A1, then conditional formting and Manage Rules... > > Cheers!! > > > > > On Fri, Jul 18, 2014 at 12:51 AM, Ahmed Emam wrote: > >> That' what i me

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-17 Thread Vaibhav Joshi
Hi Check conditional format set in sheet.. First select Cell A1, then conditional formting and Manage Rules... Cheers!! On Fri, Jul 18, 2014 at 12:51 AM, Ahmed Emam wrote: > That' what i mean but i need t know how to do it because i will apply it > to other file > > thanks > > > On Thu, Ju

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-17 Thread Ahmed Emam
That' what i mean but i need t know how to do it because i will apply it to other file thanks On Thu, Jul 17, 2014 at 10:03 AM, Vaibhav Joshi wrote: > Check this!! > > Cheers! > > > On Wed, Jul 16, 2014 at 8:47 PM, Ahmed Emam wrote: > >> I have an excel sheet and i want some cells to be highl

Re: $$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-17 Thread Vaibhav Joshi
Check this!! Cheers! On Wed, Jul 16, 2014 at 8:47 PM, Ahmed Emam wrote: > I have an excel sheet and i want some cells to be highlighted by some > colors if other 3 cells filled by text. > please see the attached example: > > What i mean that Cell A to be highlighted Yellow if Cell A1 filled b

$$Excel-Macros$$ Conditional Formatting for a cell based on another

2014-07-16 Thread Ahmed Emam
I have an excel sheet and i want some cells to be highlighted by some colors if other 3 cells filled by text. please see the attached example: What i mean that Cell A to be highlighted Yellow if Cell A1 filled by text And to be highlighted Blue if Cell B1 filled by text And to be highlighted Gree