Hi All,
I am trying to use data bars with a formula in conditional formatting. What I have is a table with months on the left hand column, I want the data bars to show different colors if the dates are greater than my target date in cell C2, and another color for dates that are less than C2.
I can't figure out how to use data bars with "use a formula to determine which cells to format".
Thank you very much
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 then scroll down to Manage Attachments to open the upload window.
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
May be have a try, not sure is this suit u
=$A2>$C$2, under the colour selection, use a diff font/colour, for example, Red Colour
=$A2<$C$2, use yellow colour
Last edited by AliGW; 08-18-2017 at 02:25 AM. Reason: Unnecessary quotation removed.
It requires the use of VBA to combine data bars and formula test.
More info can be found here
Please Login or Register to view this content.
https://digimac.wordpress.com/2014/0...bars-in-excel/
Last edited by Andy Pope; 08-18-2017 at 04:53 AM. Reason: Code tags corrected.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks