Hi excel.jpg
I have a formula in cell A5 that either returns the text "Supply number 2" or leaves the cell blank. I have to have the spreadsheet set up so it changes the fille colour based on if the cell is blank or has the text in it. Please can you help
Thanks
Why are people replying to other threads but not this one
It sounds to me like the feature you are looking for is called "conditional formatting": http://office.microsoft.com/en-us/ex...939.aspx?CTT=1
Originally Posted by shg
This simple workbook shows A5 coloured green if not blank and no colour if blank. It is done with Conditional Formatting using the formula
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thank you mate!!!
This simple workbook shows A5 coloured green if not blank and no colour if blank. It is done with Conditional Formatting using the formula
Formula:Please Login or Register to view this content.
You're welcome. Thanks for the feedback.
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
Click on GO ADVANCED and use the paperclip icon to open the upload window.
View Pic
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks