I'm using columns J and K.
When a cell in J (J1) is 40% or more than the cell in K (K1), I would like J1 to turn blue. Is there a way to make this happen?
Yes,
By using conditional formating..
Click on format --> conditional format. (It will open conditional format)
In conditional format dialog ...
select formula is (instead of cell value is).
and type "=J1 >= 1.40K1"
click on format button...
Select pattern tab and select "Blue Color"
Shijesh Kumar
http://shijesh.wordpress.com/
Is there a way to apply this condition to the whole column?
I followed the instructions...it's not working as far as showing color in the J cell.
I still need help from anyone who knows how to accomplish this.
Thanks!
Select cell J1 > formatting > conditional formatting >formula is
Enter it exactly like this
=J1 >= 1.40*K1
select format > patterns and then choose the pattern.
It works for me - If it is not working for you, you're not following the instructions.
Last edited by EdMac; 06-30-2008 at 09:17 AM.
Ed
_____________________________
Always learning, but never enough!
_____________________________
Thanks ED
The mod forgot the * between the 1.40 and K
Is there a way to apply this to the whole column?
copy the cell where you applied the formatOriginally Posted by novice2430
Select the remainder of the column and go to Edit|Paste Special... select Formats and click Ok.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Will it erase my data that I have in the cells?
It won't erase data but may overwrite any existing formats....
Alternatively, you can select your entire range of cells that are to be affected by the CF for example J1:J100 and then invoke the CF dialogue...
then enter the formula given by Edmac... the formula will update automatically for the remainder of the range.
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Okay,
I applied the format to all the cells in J, when there is no data in this worksheet in the J and K columns The cells show color in column J. When I place 45 in J3 and 100 in K3 the cell turns back to white in cell J3. What am I doing wrong?
Go to J3 and invoke the CF dialogue... what is the formula showing?
Microsoft MVP - Excel
Where there is a will there are many ways. Pick One!
Please read the Forum Rules
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Preferred Charities: Lupus Canada and Sick Kids Foundation.
Feel Free to Donate if you want to, for the assistance you received today.
Figured it out, I was given a formula for 140%, when I wanted 40%.
Thank you for the help it's working now!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks