Aug 27 2020 11:12 PM
I have a list that has coloured cells and text and I would like this to pull across on the drop down. Can this be done.
Aug 27 2020 11:48 PM
Aug 28 2020 01:07 AM
Aug 28 2020 05:18 AM
Aug 31 2020 12:04 AM
Thanks but I can't see how anything has changed. See attached image, from the Status tab this is my list location, but its not bring across the color formatting still :( See Image
Is there a way?
Aug 31 2020 01:09 AM
@basomers You need to copy the conditional format to the cell you highlighted.
But, more importantly, you need to make sure that the status you wish to format equals the status used in the data validation. For instance, your DV list has "Completed" whereas the CF rule checks for "Complete". Another inconsistency existed between "Ongoing " (note: trailing space!) in DV and "Ongoing" (note: no trailing space!). Fixed both and it seems to work. See attached.
Sep 02 2020 11:25 PM