Quote:
Originally Posted by Pecoflyer
Supposing you need to use the formula in F7: F100,select that range. In the Home ribbon select CF, -New Rule -use a formula...-enter =$F7<>"" and set your formatting accordingly. ( red font and fill yellow) -Ok - Apply
I also noticed you are working with some weird merging of cells. Best to get rid of that
|
Thanks again for your help.
I did what you suggested and the outcome seems to be what I seek.
I have attached 2 spreadseets detailing how I will proceed. As you will see, A Brown is the source and Training Record DRAFT1 is where the details of all employees (there are 38) will be gathered together.
On the DRAFT sheet, is there any way to show the date of a Review which isnt due, ie rather than show a blank cell it will show the date the review is due and without any CF?
Also, as mentioned above, I have 38 individual records to produce and then transfer to the consolidated sheet. The easiest way to populate the consolidated sheet is using the COPY command. What I mean is enter the link on the consolidated sheet for example, in cell E3 and drag it to the right. However as the 2 sheets are constructed differently ie Portrait and Landscape, Copy and Drag isnt immediately possible. Is there anything I can do to make this possible? Or an aternative way to do it?
Very grateful for your continuing help and guidance.
P.S. Not quite sure what you mean about weird merging of cells. Unfortunately the format of the sheet was given to me and needs to be kept that way. However I am sure there is room to persuade the boss and improve things
