thanks a lot for kavin and david and specialllllllllllll
really you have been a great help
Issa Bishara
____________
From: Tapas <tapas_ks@yahoo.
To: excelexpertsclub@
Sent: Monday, June 29, 2009 8:21:40 PM
Subject: [Excel Experts Club] Re: Compare budget and actual expenses and making conditional formating
You can use the conditional format in one cell and use the "format painter" and paste put it on the entire column. Say you have the two column in "A" and "B" and you put the conditional format in the cell B2 as =A2>B2 ... Ensure that you remove the $ sign from the formula that is DONOT put the formula as =$A$2>$B$2 .....
Once you have done this you can simply place the cursor on the cell containing the conditional format and click on teh "format painter" and then click on the entire column .... all the cell in the column will have the conditional format.
Note: "formula Painter" is a icon on the "standard toolbar".
--- In excelexpertsclub@ yahoogroups. com, "issaq8" <issaq8@...> wrote:
>
> hi there,
> i have two long columns, one is budgeted expenses and the second is actual expenses.
> i want font color for the actual expenses to be
> red if > budget
> blue if< buget
> green if = budget
>
> i don't want to use conditional formating, because i have to do it cell
> by cell, which is inconvient.
>
> regards,
> Issa B.
>
[Non-text portions of this message have been removed]
To start a new message thread, send a message to excelexpertsclub@yahoogroups.com.
Change settings via the Web (Yahoo! ID required)
Change settings via email: Switch delivery to Daily Digest | Switch format to Traditional
Visit Your Group | Yahoo! Groups Terms of Use | Unsubscribe
