Can this be done? ie. "new info" with green shading?
Can this be done? ie. "new info" with green shading?
Conditional formatting applied to cell or cells affected.
Welcome to the forum
In attached workbook conditional formatting to green fill if cells A1 to A20 are not blank
Select the range and then click on Conditional Formatting in Home Tab - new rule from formula as per picture
GreenFormat.jpg
Click *Add Reputation to thank those who helped you. Ask if anything is not clear
Also under "REVIEW" TAB
select "TRACK CHANGES"
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
Thank you very much for this information!
Thanks guys, I am refreshing so much knowledge and learning excel anew.
Jools
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks