Hi all,
I am new to Excel and have a question. What I am wanting to create is an if/then formula that when you enter a number from 1 to 9, the whole row the cell is in gets shaded red or some other colour. Any help would be much appreciated. Please help and you will receive good karma.
Cheers,
Sean
Have a look at conditional formatting which is under the Format menu
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Thanks for the quick reply. I appreciate it. I have been trying all night and then I just figured out the formula. Now if I can just figure out how to date stamp and add a clock in my spreadsheet i will be finished. the date stamp i need is when i edit a row, the date stamp will change to show the date the cell or row was edited.
The only way to do a date stamp so that it does not change when the sheet recalculates is to manual enter the deatails in the required cell or with a Worksheet change event macro.
To build a macro you will need to supply details of what rows or columns or range of cells the macro needs to monitor. Where does the macro put the date stamp .
Example Worksheet change macro
you change entry in any columns from a to e the date stamp goes into column f of the same row.
To install macro to correct location
Copy this macro
GoTo Excel
Select sheet this is to appy to
Right Click on Sheet Name Tab > select View Code
Past macro into the Worksheet Module displayed
Return to Excel & try entering data into any cell in column a to e
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks