Hello,
Could you please help me out?
I would like VBA to apply colours for cells with certain value - details attached.
This should apply to the whole sheet as soon as the value is entered.
Many thanks!
Hello,
Could you please help me out?
I would like VBA to apply colours for cells with certain value - details attached.
This should apply to the whole sheet as soon as the value is entered.
Many thanks!
Hi Daiwuliz
Please explain in more detail...Your explanation on uploaded file makes no sense...
When what happens in what cells must what conditions be met....
green (only that cell)
red (only that cell)
light grey (A:D)
yellow (only the cell)
orange (when blank, only the cell)
Last edited by sintek; 01-11-2018 at 01:29 PM.
Good Luck
I don't presume to know what I am doing, however, just like you, I too started somewhere...
One-day, One-problem at a time!!!
If you feel I have helped, please click on the star to left of post [Add Reputation]
Also....add a comment if you like!!!!
And remember...Mark Thread as Solved.
Excel Forum Rocks!!!
Sorry..
The conditions are:
if any cell in column C contains Y, change colour of that cell into green.
if N - red,
if P - yellow,
if N/A - highlight the whole row (A:C) - light grey.
So in the attached example, my expectation would be C2 (green), C3 (red), A4:C4 (grey) and C6 (orange). The file may potentially have hundreds of rows, so that would really help to visually identify the results.
Thank you!
Please Login or Register to view this content.
Please Login or Register to view this content.
Last edited by sintek; 01-12-2018 at 07:54 AM. Reason: CHANGED CODE...
Thank you for that, but it does not seem to work for me. Could you please check? Many thanks!
Works for me ....see upload
Type "P" or "N" or "N/A" etc
Thank you! Could it please be amended a bit to not be case sensitive? Thanks
ChangetoPlease Login or Register to view this content.
Please Login or Register to view this content.
Last edited by sintek; 01-19-2018 at 06:50 AM.
Perfect, thanks! One more last thing.... If I enter N/A - if changes the whole all three cells in the row (which is great), but if I change the value into any other, it A and B are still grey...
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks