Hi
This is regarding conditional formatting in excel 2007.
My condition is if
Cell B2 is filled with red color then cell A2 should change to green .
Please help .
Thanks
Hi
This is regarding conditional formatting in excel 2007.
My condition is if
Cell B2 is filled with red color then cell A2 should change to green .
Please help .
Thanks
On what condition is B2 red?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
I will fill B colum manually
Last edited by Shradharani; 10-18-2012 at 08:34 AM.
You will need to use VBA. You will need to apply a function to a cell in the same row, then conditionally format based on that result.
there is a function here: http://www.cpearson.com/excel/colors.aspx called "Colors in a Cell or Range:... that you would apply to some column in the sheet. Then use the result for your conditional format to see if the "colorindex" is for Red.
I m not familiar with coding ...
I can edit those but cant write ... Can u please advice me coding
Hi I got the below coding
This only works for one cell ... Can someone edit and send me the coding which I can work for rangePlease Login or Register to view this content.
Appreciate your help
Last edited by Cutter; 10-18-2012 at 10:57 AM. Reason: Added code tags
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks