Dot Grn
Need Help In Conditional Formatting?
I Need Help In EXCEL Formula
My table contain 5 columns i.e 1-company name, 2- Amount, 3- Delivery date, 4- Due date (Delivery Date+30 days credit) and 5- no of days (Todays Date-Due Date)
conditional formatting
If in Column 5 no. of days are <25 -Grn Dot
If in Column 5 no. of days are >=25 but <=30 -Yellow Dot
If in Column 5 no. of Days are <31-Red Dot
Can any one help me in this !!!!
Thx in Advance !
I don’t see what the problem is here.
Highlight all of column 5 data.
Click Format -> Conditional Formatting.
Cell value is less than 25. Set the format to green
Click Add >>
Cell value is between 25 and 30 Set format to yellow
Click Add >>
Cell value is greater than 30 Set format to red.
What more do you want to know?
Have fun.
J BIGGA – UP IN THA BOOCH FEAT DOT DOT CURVE 
You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.
Comments are closed.