Highlight cell with Fill & Font Colour
Hi,
I am working out on the IF & ELSE project. The codes created below are correct but I am not sure how to adjust the Font.
Basically i need the result of "Insufficient" to be filled with a colour on its Cell.
Fill Colour: Red
Font Colour Yellow & also Bold
Please assist.
Below are the codings:
Please Login or Register to view this content.
Last edited by FDibbins; 04-25-2016 at 10:14 AM.
Try inserting above the line starting with "Else.."
Please Login or Register to view this content.
If a response has helped then please consider rating it by clicking on *Add Reputation below the post
When your issue has been resolved don't forget to mark the thread SOLVED (click Thread Tools at top of thread)
Complete stuff.
Please Login or Register to view this content.
nuraisyah Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(I will add them for you - this time)
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Hi,Originally Posted by Kevin#
Try inserting above the line starting with "Else.."
Please Login or Register to view this content.
I have tried to copy but error occurred. It highlights at the word .worksheet
The error appeared as "invalid/unqualified reference"
Hi Kevin,
I did try n error and i have found the solution and yes it works!
I am a beginner, i'd like to add the color coding for "Sufficient" Result.
May i know what is the coding for Font color white? and font not bold?
Kindly assist.
Thanks.
nuraisyah,
Do you need to loop?
No loop and conditional format.
Please Login or Register to view this content.
Last edited by jindon; 04-27-2016 at 12:14 AM.
In response to post#6
"and font not bold?"
Please Login or Register to view this content.
"what is the coding for Font color white? "
-3 different ways to get a white font
ORPlease Login or Register to view this content.
ORPlease Login or Register to view this content.
This link will help you with coloursPlease Login or Register to view this content.
Last edited by Kevin#; 04-27-2016 at 12:23 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks