LinkBack URL
About LinkBacks
Hi There,
I need to colour the attached excel sheet(D3:H23) using conditional formatting and IF function. Following is the condition. If E3 is greater than D3, colour Green. If E3 less than D3, colour Red. If E3 is blank colour yellow.
Hi There,
I need to colour the attached excel sheet(D3:H23) using conditional formatting and IF function. Following is the condition. If E3 is greater than D3, colour Green. If E3 less than D3, colour Red. If E3 is blank colour yellow.
hi there. select the range you want to apply to (say from D3:H23)
go to Home tab -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=$E3>$D3
format green
but what about those rows in between showing percentage? if you want them like the above, then that works. otherwise, use this instead:
=AND($E3>$D3,$A3<>"")
repeat the steps for other colors. Red is:
=AND($E3<$D3,$A3<>"")
blank is:
=AND($E3<>"",$A3<>"")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Hi,
Thank you so much for the reply.
I applied the formula =AND($E3>$D3,$A3<>"") but, it didn't give me the exact result i want. To be clear. If the amount in the cell E3 is greater than the amount in the cell D3, it should colour green. And the amount in the cell F3 is lesser than the amount in the cell E3 it should colour red.
Likewise, the colouring should be done comparing with the amount in the adjacent cell. Attaching the sheet to let you know what happened when i applied the formula =AND($E3>$D3,$A3<>""). Please let me know if i did anything wrong.
Re: Conditional formatting using if function
is that what you want?
or I misunderstood...
Than you for the reply Sandy.
But this is not what i need. AIG, EPSILON, JPMC etc are the clients and 12/24/17, 12/31/17, 01/07/18 etc are the week ending dates. The values in dollars are the sales for the particular week. So i need to easily compare the sales with the previous week's sales. If the sales increases compared to the previous week's sales, need to colour green and if the sales are less than the previous week, colour red. And if the sales column is blank, colour yellow.
For eg : If the sales sales of AIG for the week ending 12/31/2017 (E3) is more than the previous week 12/24/2017(D3), E3 should be in green. If the sales of AIG for 12/31/17 (E3) is less than the previous week 12/24/2017 (D3), E3 should be in red.
likewise i need to colour E3:Q21. I did the colouring manually in the attached file. Please refer.
no attached file to post #5
Re: Conditional formatting using if function
but maybe this one
i've uploaded an example of how you should show us your sample sheet under the Manual worksheet. i manually highlighted the results i wish to see. that helps us understand a lot better.
and in CF worksheet, i did the conditional formatting for you. so the adjustments are now:
select the range you want to apply to (say from E3:Q24)
go to Home tab -> Conditional Formatting -> New Rule -> Use a formula to determine which cells to format -> Format values where this formula is true:
=AND(E3>D3,$A3<>"")
format green
repeat for red:
=AND(E3<D3,$A3<>"")
blank:
=AND(E3="",$A3<>"")
Thank you all..
You are welcome
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks